DBMS – Complete Practical Approach

20 Mike ADD_MONTHS anonymous block assign BEGIN bitmap index Blood_type Boolean bytes CHAR CLOB collection column name command company_id constraint CREATE TABLE cursor variable database triggers datatype DECLARE TYPE defined dept deptno display DUAL elements employee table EMPNO ENAME END LOOP error exception handler exception section executable statements explicit cursor FETCH following example foreign key formal parameters format function returns global GOTO HIREDATE INSERT INTEGER keyword last_name module Nested Block nested table NOIDA NULL object operator optional Oracle Oracle Forms owes_us package body package specification PL/SQL block positional notation primary key procedure query record REF CURSOR type reference retrieve RETURN NUMBER RETURN statement RETURN VARCHAR2 ROLLBACK ROWID ROWTYPE salary savepoint SELECT statement sequence server SOUNDEX specified SQL statement SQL*Plus stored string structure subprogram subquery syntax SYSDATE Table Name tablespace TO_CHAR TO_DATE tot_sales trigger TRUNC VARCHAR2 varray vtable