Sunday, 23 June 2013

desc employee_rishav;
select ABS(-15) from dual;
select CEIL(15.7) from dual;
select FLOOR(15.7) from dual;
select MOD(7,5) from dual;
select POWER(5,2) from dual;
select ROUND(5.3648,2) from dual;
select SQRT(9) from dual;
select TRUNC(45.52,1) from dual;
select CONCAT('my name is','RAHUL') from dual;
select LOWER('RAHUL KUMAR') from dual;
select INITCAP('RAHUL') from dual;
select LENGTH('RAHUL KUMAR') from dual;
select TRIM(003400) from dual;
select UPPER('Rahul kumar') from dual;
select LTRIM('ra rahul','ra') from dual;
select RTRIM('rahul ra','ra') from dual;
select SYSDATE from dual;
select CURRENT_DATE from dual;
select ADD_MONTHS('23-MAY-1994',5) from dual;
select NEXT_DAY('1-JUNE-2013','THURSDAY') from dual;

No comments:

Post a Comment