Oracle

#########################################
#  Smashing Dr.Ahmad FOR Fun AND Profit  #
#########################################
Basic Code Block Command :
    DECLARE
    BEGIN
    END
    EXCEPTION

Data TYPE :
    VARCHAR2
    VARCHAR
    NUMBER
    INT
    DATE
TO Get TYPE FROM TABLE :
    e.g :
        name student.s_name%TYPE;

Basic Code
    variable_name := VALUE;
    SET SERVEROUTPUT ON;
    DBMS_OUTPUT.PUT_LINE('display_text');
    new_string := string1 || string2;
    LTRIM();
    RTRIM();
    LENGTH();
    UPPER();
    LOWER();
    IF condition1 THEN
        ...
    ELSIF condition2 THEN
        ...
    ELSE
        ...
    END IF;


WHILE condition LOOP
     program statements
END LOOP;


LOOP
    ...
END LOOP;



Steps FOR creating AND USING explicit CURSOR :
    - DECLARE CURSOR
    - OPEN CURSOR
    - FETCH data ROWS
    - CLOSE CURSOR


e.g

DECLARE
    CURSOR c IS SELECT s_id , s_name FROM student;
    id student.s_id%TYPE;
    name student.s_name%TYPE;
BEGIN
    OPEN c;
    LOOP
        FETCH c INTO id , name;
        EXIT WHEN c%NOTFOUND;
        dbms_output.put_line(id || '   ' || name);
    END LOOP;
    CLOSE c;
END;