Data Warehousing Community Forum
February 08, 2012, 10:02:19 am

Pages: [1]   Go Down
  Print  
Author Topic: What is PL/SQL ?  (Read 694 times)
Sipra
Founder
*****

Reputation: +59/-0
Offline Offline

Posts: 323


Am the King...


View Profile WWW
« on: June 29, 2007, 01:34:30 pm »

What is PL/SQL ?

We are having SQL - Structured Query Language, what is the essence/need of having PL/SQL?

Can anyone describe waht are all the advantages of using PL/SQL?

Thanks in Advance...
Logged

Whoever
Administrator
*****

Reputation: +34/-0
Offline Offline

Posts: 124



View Profile WWW
« Reply #1 on: July 02, 2007, 01:38:30 pm »

PL/SQL is Oracle's procedural language extension to SQL. PL/SQL enables you to mix SQL statements with procedural constructs.

With PL/SQL, you can define and execute PL/SQL program units such as Procedures, Functions and Packages.

PL/SQL program units gernerally categorized as Anonymus blocks and Stored Procedures.

PL/SQL is completely portable, hifh-performance transaction processing language that offers the following advantages -

  • Support to SQL
  • Higher productivity
  • Better performance
  • Portability
  • Integration with Oracle
Logged

If most people said what’s on their minds, they’d be speechless.
Pages: [1]   Go Up
  Print  
 
Jump to: