1. RUNTIME STRING/NUM PRINTING SET SERVEROUTPUT ON BEGIN DBMS_OUTPUT.PUT_LINE('ORANGE'); END; / 2. TIMESTAMP EXAMPLE SET SERVEROUTPUT ON DECLARE V_DATE TIMESTAMP; BEGIN SELECT SYSTIMESTAMP-1/24 INTO V_DATE FROM DUAL; DBMS_OUTPUT.PUT_LINE('ONE HR. AGO :: ' || V_DATE); END; / 3. TIMESTAMP EXAMPLE WITH EXCEPTION HANDELING SET SERVEROUTPUT ON DECLARE VDATE TIMESTAMP; BEGIN SELECT SYSTIMESTAMP INTO VDATE FROM DUAL; DBMS_OUTPUT.PUT_LINE(VDATE); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('ERROR'); END; / 4. LOOP & SERIES PRINTING SET SERVEROUTPUT ON DECLARE X NUMBER:=1; BEGIN LOOP EXIT WHEN X>10; DBMS_OUTPUT.PUT_LINE(X); X:=X+1; END LOOP; END; / 5. TABLE JOINING & CURSORING CREATE TABLE AUTHORS ( ID NUMBER PRIMARY KEY, FIRST_NAME VARCHAR2(50), LAST_NAME VARCHAR2(50) ); CREATE TABLE BOOKS ( ISBN CHAR(10) PRIMARY KEY, CATEGORY VARCHAR2(20), TITLE VARCHAR2(100), NUM_PAGE NUMBER, PRICE NUMB