tips to study ncert books civil services syllabus ias general studies notes links bicameral legislature genetically modified crops ias topper anudeep durishetty highest peak in india tele law pcpndt act panchsheel upsc air 2 akshat jain prime minister of india salary jnanpith award comments leave a...
Frommonth :=to_number(substr(birthst,6,2));ifTomonth-Frommonth>0thenV_birth:=Toyear-fromyear;elseV_birth:=Toyear-fromyear-1;endif;return(V_birth);end;functiongetSalary(VFpsncodevarchar)returnnumberisV_psnSalarynumber(8,2);beginSelectFpsnSalaryintoV_psnSalaryfromT_PsnSalarywhereFpsncode=VF...
在导入之前,hr.staffs表的数据是存在的。 human_resource=#select*fromhr.staffs;staff_id|first_name|last_name|email|phone_number|hire_date|employment_id|salary|commission_pct|manager_id|section_id---+---+---+---+---+---+---+---+---+---+---200|Jennifer|Whalen|JWHALEN|515.123.4444...
human_resource=# select * from hr.staffs;staff_id|first_name|last_name|email|phone_number|hire_date|employment_id|salary|commission_pct|manager_id|section_id---+---+---+---+---+---+---+---+---+---+---(0rows) 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. 14...
create table test1 (id integer,name varchar(20),salary float,time date,addr varchar(200),primary key(id)) ; insert into test1 values (1,'zhangsan',2000.00,'2018-06-01 00:00:00','beijing'); insert into test1 values (2,'李四',2000.89,'2018-06-01 00:00:00','西安'); ...