Tag: programming languages

SELECT CEIL(15.7) "Ceiling" FROM DUAL;

SELECT FLOOR(15.7) "Floor" FROM DUAL;

SELECT REPLACE('JACK and JUE','J','BL')FROM DUAL;

SELECT MONTHS_BETWEEN TO_DATE('02-01-1995','MM-DD-YYYY'),TO_DATE('01-01-1995','MM-DD-YYYY') ) FROM DUAL;

SELECT POWER(3,2) FROM DUAL;

SELECT TO_CHAR( ADD_MONTHS(to_date('07-JUN-1994,'DD-MON-YYYY'),1), 'DD-MON-YYYY') FROM employees WHERE last_name = 'Baer';

SELECT SIN(30 * 3.14159265359/180) FROM DUAL;

SELECT MOD(11,4)FROM DUAL;

SELECT SQRT(25) FROM DUAL;

SELECT LENGTHB ('CANDIDE') FROM DUAL;