EBS_TEC_PLSQL 1.0.ppt

PL/SQL PL/SQL Fundamentals Prepared By TATA CONSULTANCY SERVICES PL/SQL PL/SQL is Oracle corporations procedural language extension to SQL,the standard data access language for RDBMS and ORDBMS It brings state-of-the-art programming to the Oracle server and Tool set Contains all SQL DML functionality PL/SQL Architecture PL/SQL runtime system is a technology,not an independent product. This technology is an engine that executes PL/SQL blocks and subprograms PL/SQL resides in two environments: Oracle server Oracle tools PL/SQL engine accepts PL/SQL block or subprograms a