Simple query statements for Oracle Learning

--display dates in a specific formatSelectEname,to_char (HireDate,'YYYY "Year" MM "month" DD "Day"') fromEMP;--Exclude Duplicate rowsSelect distinctDeptno,job fromEMP;SelectDeptno,job fromEMP;--handling NULL using the NVL functionSelectename, SAL,COMM,NVL (comm,0.00), Sal+NVL (Comm,0) fromEMP;--handling NULL using NVL2SelectENAME,SAL,COMM,NVL2 (comm,sal+Comm,sal) fromEmp--returns the value of Sal if Comm is null and returns the value of Sal+comm if Comm is not null--Connection StringSelectEname||" '"||'S Job is'||Job fromEMP;--using column AliasesSelectEname "Name", Sal "salary" fromEmp

Simple query statements for Oracle Learning