Category Archives: pl/sql

Block Structure [DECLARE — declarations] BEGIN [EXCEPTION — handlers] END; Variables Declaring Variables * SQL data types DECLARE part_no NUMBER(6); part_name VARCHAR2(20); in_stock BOOLEAN; part_price NUMBER(6,2); part_desc VARCHAR2(50); * %TYPE, %ROWTYPE v_last_name employees.last_name%TYPE; dept_rec departments%ROWTYPE; SET SERVEROUT ON DECLARE CURSOR … Continue reading →