SELECT CEIL(8.29) FROM DUAL;
SELECT CEIL(-3.9) FROM DUAL;
SELECT CEIL(17 / 3) FROM DUAL;
SELECT FLOOR(9.76) FROM DUAL;
SELECT FLOOR(-5.3) FROM DUAL;
SELECT FLOOR(15 / 4) FROM DUAL;
SELECT SQRT(625) FROM DUAL;
SELECT SQRT(2) FROM DUAL;
SELECT ABS(8.29) FROM DUAL;
SELECT ABS(-3.14) FROM DUAL;
SELECT ABS(-42) FROM DUAL;
SELECT SYSDATE AS NOW FROM DUAL;

SELECT TO_CHAR(SYSDATE, 'YYYY-MM-DD') AS DATE_FORMAT,
       TO_CHAR(SYSDATE, 'HH:MI:SS AM') AS TIME_FORMAT
FROM DUAL;

SELECT SYSTIMESTAMP FROM DUAL;

SELECT LEAST('Apple', 'Banana', 'Cherry') FROM DUAL;
SELECT GREATEST('Apple', 'Banana', 'Cherry') FROM DUAL;
SELECT LTRIM('  Trim me') FROM DUAL;
SELECT RTRIM('I love India                ') FROM DUAL;
SELECT RPAD('YourName', 15, 'X') FROM DUAL;
SELECT RPAD(123, 6, '0') FROM DUAL;
SELECT REVERSE('uoy evol I') FROM DUAL;
SELECT CASE WHEN 'racecar' = REVERSE('racecar') THEN 'Palindrome' ELSE 'Not Palindrome' END AS RESULT FROM DUAL;
SELECT LENGTH('Oracle Database') FROM DUAL;
SELECT 'Oracle' || ' ' || 'SQL' || ' ' || 'is' || ' ' || 'powerful' || ' ' || 'flexible' FROM DUAL;
SELECT CONCAT('John','Doe') FROM DUAL;
SELECT SUBSTR('India is my country', INSTR('India is my country', 'is'), 2) FROM DUAL;
SELECT SUBSTR('John', 2, 3) FROM DUAL;
SELECT SUBSTR('Substring', 1, 3) FROM DUAL;