SQL commands taught on 7th August 2010 Class

Code:



select lpad(salary,10,'*') from hr.employees;

 
select round(102.926,2) from dual;

 
select trunc(45.929,2) from dual;

 
select round(127.49, -1) from dual;

 
select round(123.49, -1) from dual;

 
select trunc(126.49, -1) from dual;

 
select round(187.49, -2) from dual;

 
select round(550.49, -2) from dual;

 
select round(500.49, -2) from dual;

 
select trunc(160.49, -2) from dual;

 
select sysdate from dual

 
select last_name, (SYSDATE-hire_date)/7 as weeks

from hr.employees;

 
select sysdate from dual;

 
select to_char(sysdate,'DD-Month-RR') from dual;

 
select to_char(sysdate,'DD-Month-rr') from dual;

 
select to_char(sysdate-2, 'D Month-RR') from dual;

 
select months_between('01-oct-2010',sysdate) from dual;

 
select to_char(next_day('01-aug-10','FRIDAY'),'DD-Month-RR') from dual;

 
select last_day('01-Feb-08') from dual;

 
select to_char(Last_day('07-aug-10'),'MOnth') from dual;

 
select to_char(sysdate,'DD-Month-RRRR');

 
select sysdate from dual;

 
select to_char(round(sysdate, 'month'),'DDth-Month-RRRR') from dual;

 
select to_char(sysdate-172, 'dd-month-RRRR') from dual

 
select round(sysdate-172, 'Month') from dual

 
select round (sysdate-38,'year') from dual;

 
select round (sysdate,'year') from dual;

 
select round(to_char('14-Feb-2010', 'dd-mon-RRRR'),'month') from dual

 
select trunc(sysdate, 'year') from dual

 
select trunc(sysdate, 'month') from dual

 
select to_char(sysdate,'year') from dual;

 
select to_char(sysdate,'RRRR') from dual;

 
select to_char(sysdate,'RR') from dual;

 
 
select to_char(12345, '99999999') from dual;

 
select to_char(12345, '099999999') from dual;

 
select to_char(12345, '99.999') from dual;

 
select to_char(-12345, '99999999PR') from dual;

 
select to_char(12345, '99999999PR') from dual;



bit0112-rokon wrote:is it possible to elaborate all the commands..?