2006-10-26 22:39:40 · 3 answers · asked by prakash's IQ 1 in Computers & Internet ➔ Programming & Design
PL/SQL(Procedural Language/SQL) is a programming language from Oracle that is used to add additional processing (sorting and other manipulation) of the data that has been returned by the SQL query. A PL/SQL program is structured as a "block," which is made up of declaration, executable commands and exception handling sections.
PL/SQL supports variables, conditions, arrays, and exceptions. Implementations from version 8 of the Oracle RDBMS onwards have included features associated with object-orientation.
PL/SQL stored procedures (functions, procedures, packages, and triggers) which perform DML get compiled into an Oracle database: to this extent their SQL code can undergo syntax-checking. Programmers working in an Oracle database environment can construct PL/SQL blocks of such functionality to serve as procedures, functions; or they can write in-line segments of PL/SQL within SQL*Plus scripts.
2006-10-27 00:54:00 · answer #1 · answered by Y Raghavendra Reddy 2 · 0⤊ 0⤋
PL/SQL?
Not sure, When i program i use PL as a perl file. IE:
getdata.pl and in that file will be code to access the SQL server.
However i feel this may not be your answer, Try doing a search for PL SQL or PL/SQL on www.google.com and see what comes up.
2006-10-26 22:58:30 · answer #2 · answered by Funky G 5 · 0⤊ 0⤋
PL in PL/SQL is Procedural Language. SQL does not have any procedural capabilities such as looping and branching and it does not have any conditional checkng capabilities .
PL adds to the power of SQL by providing such facilities and a Programming environment.
2006-10-26 23:12:39 · answer #3 · answered by Dhara D 1 · 1⤊ 0⤋