SQL Tutorial : DRL / DQL - FUNCTIONS

SQL Tutorial : DRL / DQL - FUNCTIONS

Let's learn about next topic: FUNCTIONS

FUNCTIONS:

************

- DUAL TABLE: ONE COLUMN DUMMY AND ONE ROW X

- PREDEFINED PROGRAMS USED FOR COMPUATATIONS

- FUNCTIONS MAY OR MAY NOT ACCEPT I/P

- BUT MUST RETURN A SINGLE O/P

- SINGLE I/P THEN SINGLE ROW FUNCTION:

 * CHARACTER

  * CASE MANIPULATION 

  * LOWER, UPPER,INITCAP

- SELECT UPPER('bangalore'),LOWER('BANGALORE') , INITCAP('CHENNAI BEACH')

FROM DUAL

- SELECT UPPER(LAST_NAME),INITCAP(JOB_ID)

FROM EMPLOYEES
WHERE DEPARTMENT_ID=30