Data Warehousing Community Forum
October 24, 2019, 01:15:10 am

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

Reputation: +56/-0
Offline Offline

Posts: 354


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

advertisement
Whoever
Administrator
*****

Reputation: +55/-0
Offline Offline

Posts: 145



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

Wenn ist das Nunstück git und Slotermeyer? Ja! … Beiherhund das Oder die Flipperwaldt gersput.
Pages: [1]   Go Up
  Print  
Jump to: