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:

  • Most Important Data dictionary Queries.. Data dictionary queries Check if a table exists in the current database schema A simple query that can be used to check if a table exists before you create it. This way you can make your create table script rerunnable. Just… Read More
  • Weblogic Server 11g 10.3.3 on MS Windows 7 Weblogic Server Installation 11g 10.3.3 on MS Windows 7 We download the Oracle Weblogic server from here. We started the installer and will see at the beginning the initial loading. Wait until the loading of the insta… Read More
  • Oracle date and time function related queries Date / Time related queries Get the first day of the month Quickly returns the first day of current month. Instead of current month you want to find first day of month where a date falls, replace SYSDATE with any date colu… Read More
  • Database administration queries Database administration queries Database version informationReturns the Oracle database version. SELECT * FROM v$version; Database default information Some system default information. SELECT username,profile,default_ta… Read More
  • Utility / Math related queries Utility / Math related queries Convert number to words More info: Converting number into words in Oracle SELECT TO_CHAR (TO_DATE (1526, 'j'), 'jsp') FROM DUAL; Output: one thousand five hundred twenty-six Find st… 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