What is PL/SQL ?

PL/SQL  is  a  procedural  language  that  has  both  interactive  SQL  and procedural  programming  language constructs such as iteration, conditional branching.

Showing Answers 1 - 2 of 2 Answers

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.

  Was this answer useful?  Yes

Nagendra

  • 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.

  Was this answer useful?  Yes

rajesh

  • 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.

Yestha Bapna

  • 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

  Was this answer useful?  Yes

narender sharma

  • Oct 30th, 2007
 

Pl/Sql is a procedural extension to sql with design feature of programming language.

  Was this answer useful?  Yes

g_sidhu

  • 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.

  Was this answer useful?  Yes

surya72446

  • Sep 30th, 2009
 

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions