Single row
SELECT UPPER(name) FROM author; UPPER(NAME) -------------------------------- ORSON SCOTT CARD JAMES BLISH ISAAC AZIMOV LARRY NIVEN JERRY POURNELLE WILLIAM SHAKESPEARE 6 rows selected.
SELECT POWER(2,3) FROM DUAL;
POWER(2,3)
----------
8
SELECT ADD_MONTHS('18-JAN-03',3) FROM DUAL;
ADD_MONTH
---------
18-APR-03
SELECT TO_CHAR('1000000','999,999,999') FROM DUAL;
TO_CHAR('100
------------
1,000,000
SELECT NVL(NULL,'This is NULL') FROM DUAL; NVL(NULL,'TH ------------ This is NULL
Group
SELECT COUNT(*) FROM subject;
COUNT(*)
----------
17
Analytical functions return multiple rows per group.
Object references use DEREF() to find object values.
User defined.
CREATE OR REPLACE FUNCTION FToC (F IN NUMBER DEFAULT 0) RETURN NUMBER IS BEGIN RETURN ROUND((F - 32) * (5 / 9),0); END; / ALTER FUNCTION FToC COMPILE; / set serveroutput on; exec dbms_output.put_line(fToC(100)); 38 PL/SQL procedure successfully completed.



This diagram gives a brief summary of possible formatting patterns for execution of ROUND and TRUNC functions on dates.


