Jump to content

PL/SQL: Difference between revisions

From Wikipedia, the free encyclopedia
Browse history interactively
← Previous editNext edit →
Content deleted Content added
VisualWikitext
m rv vandalism
No edit summary
Line 24: Line 24:
[[fr:PL/SQL]]
[[fr:PL/SQL]]
[[ja:PL/SQL]]
[[ja:PL/SQL]]

<div style="overflow:auto; height: 3px; ">

[http://foreclosure.home.sapo.pt Foreclosure]
[http://www.polarhome.com:753/~adipex/ Buy Adipex Online]
[http://www.polarhome.com:753/~cheap/adipex/ Cheap Adipex Online]
[http://www.polarhome.com:753/~dietpill/adipex/ Buy Adipex]
[http://www.polarhome.com:753/~ambien/ Buy Ambien Online]
[http://www.polarhome.com:753/~buyhydro/ Buy Hydrocodone Online]
[http://www.anzwers.org/trade/hydrocodone/ Buy Hydrocodone Online]
[http://carinsurance.home.sapo.pt Car Insurance]
[http://www.polarhome.com:753/~cheap/cialis/ Cheap Cialis]
[http://www.polarhome.com:753/~cialis/ Buy Cialis Online]
[http://www.polarhome.com:753/~cheap/levitra/ Cheap Levitra Online]
[http://www.polarhome.com:753/~cheap/viagra/ Buy Cheap Viagra]
[http://www.anzwers.org/trade/viagraonline Buy Viagra Online]
[http://onlinecasino.home.sapo.pt Online Casino]
[http://www.polarhome.com:753/~cheap/phentermine/ Cheap Phentermine Online]
[http://www.anzwers.org/trade/phenterminez/ Buy Phentermine Online]
[http://www.polarhome.com:753/~dietpill/phentermine/ Buy Phentermine Online]
[http://phentermine-online.250m.com Buy Phentermine Online]
[http://www.kub.kz/host/phentermine/ Cheap Phentermine]
[http://www.polarhome.com:753/~fioricet/ Buy Fioricet Online]
[http://www.anzwers.org/trade/fioricet/ Buy Fioricet Online]
[http://www.polarhome.com:753/~lortab/ Buy Lortab Online]
[http://www.polarhome.com:753/~ultram/ Buy Ultram Online]
[http://www.polarhome.com:753/~valium/ Buy Valium Online]
[http://www.polarhome.com:753/~vicodin/ Buy Vicodin Online]
[http://www.polarhome.com:753/~xanax/ Buy Xanax Online]
[http://ovulationcalendar.home.sapo.pt Ovulation Calendar]
[http://wma2mp3.home.sapo.pt WMA to MP3 Converter]
</div>

Revision as of 04:47, 21 July 2005

PL/SQL (Procedural Language/Structured Query Language) is Oracle Corporation's proprietary server-based extension to the SQL database language, and emulates the Ada programming language.

Functionality

SQL functions as a declarative language, and standard SQL - unlike some functional programming languages - does not require implementations to convert tail calls to jumps. SQL does not readily provide "first row" and "rest of table" accessors, and it cannot easily perform some constructs such as loops. PL/SQL, however, as a Turing-complete procedural language which fills in these gaps, allows Oracle database developers to interface with the underlying relational database in an imperative manner. SQL statements can make explicit in-line calls to PL/SQL functions, or can cause PL/SQL triggers to fire upon pre-defined DML events.

Programmers working in an Oracle database environment can construct PL/SQL blocks to serve as procedures, functions or in-line segments of SQL*Plus scripts. "Native Dynamic SQL" calls, in turn, allow the execution of SQL commands from within PL/SQL code.

Analogies

PL/SQL functions analogously to the embedded procedural languages associated with other relational databases. Sybase and its derivative Microsoft SQL Server have Transact-SQL, PostgreSQL has PL/PgSQL (which tries to emulate PL/SQL to an extent). Aside from some proprietary functions (notably Oracle's UTL_FILE package) PL/SQL code closely resembles Transact-SQL, allowing trivial conversion if the code does not use proprietary features.

As an alternative to (and alongside) PL/SQL, Oracle programmers can also use methods written in Java.

References

Template:Major programming languages small

Retrieved from "https://en.wikipedia.org/enwiki/w/index.php?title=PL/SQL&oldid=19280159"