Tuesday, 8 July 2014

undefined undefined







Advantages of PL/SQL



These are the Advantages of PL/SQL

Block Structures: PL SQL consists of blocks of code, which can be nested within each other. Each block forms a unit of a task or a logical module. PL/SQL Blocks can be stored in the database and reused.

Procedural Language Capability: PL SQL consists of procedural language constructs such as conditional statements (if else statements) and loops like (FOR loops).

Better Performance: PL SQL engine processes multiple SQL statements simultaneously as a single block, thereby reducing network traffic.

Error Handling:
PL/SQL handles errors or exceptions effectively during the execution of a PL/SQL program. Once an exception is caught, specific actions can be taken depending upon the type of the exception or it can be displayed to the user with a message.

Ability to work with real time scenario 

Tight integration with SQL

Full Portability


Related Posts:

  • ORACLE-FORU - PL/SQL code for SPACE AFTER EACH LETTER pl/sql program to insert a space after each  letter in a  given string.  Procedure: declare      str varchar(10):='&str';      len number(2);       i number(3… Read More
  • ORACLE-FORU - Bulk Collect In Oracle Bulk Collect In Oracle Definition of Bulk Collect:- Bulk binds can improve the performance when loading collections from a queries. The BULK COLLECT INTO construct binds the output of the query to t… Read More
  • ORACLE-FORU - PL/SQL code for LETTER BY LETTER pl/sql program to print a string in a letter by letter format. Procedure:   declare       str varchar(10):='&str';       len number(2);       i number(3):=1;   beg… Read More
  • ORACLE-FORU - PL/SQL code for Reverse Of A Number pl/sql program to generate reverse for given number. Procedure: declare      n number(4):=&n;      s number(4):=0;      r number(4);  begin      while n&… Read More
  • PL/SQL Functions What is a Function in PL/SQL? A function is a named PL/SQL Block which is similar to a procedure. The major difference between a procedure and a function is, a function must always return a value, b… Read More

0 comments:

Post a Comment

Copyright © 2025 ORACLE-FORU - SQL, PL/SQL and ORACLE D2K(FORMS AND REPORTS) collections | Powered by Blogger
Design by N.Design Studio | Blogger Theme by NewBloggerThemes.com