You are currently browsing the articles from Techno Oracle matching the category
Anonymous Block An anonymous block is a PL/SQL block without a name for identification.It has to be brought to the server’s memory every time it is required .Anonymous Block can’t be accessed/referred neither by oracle nor by user for execution.It has to be compiled every time we need that block of statements Stored Procedures A [...]
Written by admin on August 17th, 2010 with 1 comment.
Read more articles on Introduction to PL/SQL and Oracle PL/SQL.
The PL/SQL compilation and run-time system is an engine that compiles and executes PL/SQL blocks and subprograms. The engine can be installed in an Oracle server or in an application development tool such as Oracle Forms. In either environment, the PL/SQL engine accepts as input any valid PL/SQL block or subprogram. Figure shows the PL/SQL [...]
Written by admin on August 16th, 2010 with no comments.
Read more articles on Introduction to PL/SQL and Oracle PL/SQL.
This chapter introduces PL/SQL Basics,PL SQL Block structure,PL SQL Architecture,Advantage of PL/SQL etc. What Is PL/SQL? PL/SQL stands for Procedural Language extensions to traditional SQL. PL/SQL is available as an enabling technology within other software products. PL/SQL does not exist as a standalone language. We can use PL/SQL in the Oracle database, in the Oracle [...]
Written by admin on June 17th, 2010 with no comments.
Read more articles on Introduction to PL/SQL and Oracle PL/SQL.