PL/SQL is Oracle's Procedural Language extension to SQL. PL/SQL's language syntax, structure and datatypes are similar to that of ADA. The language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance), and so, brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools.
Login to rate this answer.
Nagendra
Answered On : Mar 3rd, 2006
Hi Sir,
1.What is PL/SQL ?
Answer :
PL/SQL is Procedural Language extension to SQL. PL/SQL's language syntax, structure and datatypes are similar to that of ADA. The language includes object oriented programming techniques such as encapsulation, function overloading, information hiding (all but inheritance), and so, brings state-of-the-art programming to the Oracle database server and a variety of Oracle tools.
Login to rate this answer.
hii
pl/sql is procedural language extenction to structure query language.
Login to rate this answer.
rajesh
Answered On : Jul 23rd, 2007
PL/SQL is a procedural language that Oracle developed as an extension to standard SQL to provide a way to execute procedural logic on the database.
New Term - If you have worked with relational databases in the past, you are no doubt familiar with SQL, which stands for Structured Query Language. SQL itself is a powerful declarative language. It is declarative in the sense that you describe the results that you want but not how they are obtained. This is good because you can insulate an application from the specifics of how the data is physically stored. A competent SQL programmer can also push a great deal of processing work back to the server level through the creative use of SQL.
1 User has rated as useful.
Login to rate this answer.
Yestha Bapna
Answered On : Aug 14th, 2007
PL SQL is a block structured programming language. It combines data manipulation & data processing power. It supports all SQL data types. Also has its own data types i,e BOOLEAN,BINARY INTEGER
Login to rate this answer.
narender sharma
Answered On : Oct 30th, 2007
Pl/Sql is a procedural extension to sql with design feature of programming language.
Login to rate this answer.
PL/SQL is procedural extension to SQL with design feature of programming language.
Login to rate this answer.
g_sidhu
Answered On : Feb 16th, 2008
PL/SQL is the procedural extension to SQL with design features of programming languages. Data manipulation and query statements of SQL are included within procedural units of code. PL/SQL offers modern software engineering features such as data encapsulation, exception handling, information hiding, object orientation.
Login to rate this answer.
PL/SQL stands for procedural languages extensions to SQL and it's theme is to hold a bunch of SQL statements as a single function and return a single output.
PL/SQL is advantageous compared to other programming languages as it is a Oracle proprietary and does not require any external interfaces for the database connectivity.
Login to rate this answer.
