Shudydgeiwoao

1. SELECT START_DATE SALARY NVL( SALARY DA (SALARY, 280)), to DATE(START DATE ,"Monthddsp, YYYY ) FROM WORKERS ORDER BY START DATE DESC,




 2. SELECT WNAME, NICAPT(PNAME) FROM PROJECTS P JOIN WORKERS W USIND (PID) ON(P.PID=W.PID .p WHERE DA<15;





3. SELECT WNAME, PNAME ,NVL (SALARY, SALARY) FROM PROJECTS P FULL OUTER JOIN WORKERS W ON(P.PID=W.PID) order by salary;





 4. SELECT PNAME, CASE PRAME) k us WHEN LENGTH(PNAME, 8) THEN "SMALL" WHEN LENGTH(PNAME, 9) THEN "AVERAGE ELSE LENGTHY END"COMMENT" On FROM PROJECTS; 0.W 048


substr
instr
replace(
coalesce