This Oracle PL/SQL Tutorial course teaches you how to use basics of PL/SQL programming language. PL/SQL is the procedural extension of SQL language. PL/SQL Tutorial Introduction PL/SQL (Procedural Language / Structured Query Language) is the procedural extension of SQL language. PL/SQL...
PL/SQL Blocks The structure of a PL/SQL block PL/SQL is a language structured on the block. A PL/SQL block consists of 3 parts: declarative (optional), executable (required) and handling exceptions (optional). PL/SQL is a language focused on blocks. These blocks are...
PL/SQL Variables Variables can be any SQL data type such as CHAR, DATE, NUMBER or PL/SQL data type such as BOOLEAN or PLS_INTEGER. Declare data type for variables in PL/SQL You can use the special words %ROWTYPE or %TYPE to declare...
PL/SQL Control structures IF IF-THEN, IF-THEN-ELSE and IF-THEN-ELSIF. Example: DECLARE x NUMBER:=5; y NUMBER:=3; z NUMBER:=0; BEGIN IF x > y THEN z:=x; DBMS_OUTPUT.PUT_LINE(z); ELSIF x < y THEN z:=y; DBMS_OUTPUT.PUT_LINE(z); ELSE z:=-1; DBMS_OUTPUT.PUT_LINE(z); END IF; END; Example: DECLARE v_dept_id NUMBER;...
PL/SQL Collections and Records Collections and recordings are compound data types containing internal elements like array, record or table. Collections Collections are data types that allow simultaneous processing of multiple variables of the same type. Each element has a unique index,...