What is pl/sql and what is it used for?

Answers were Sorted based on User's Feedback



What is pl/sql and what is it used for?..

Answer / pavan_1981

PL/SQL is Oracle's Procedural Language extension to SQL.
PL/SQL's language syntax, structure and data types are
similar to that of ADA. The PL/SQL language includes object
oriented programming techniques such as encapsulation,
function overloading, information hiding (all but
inheritance). PL/SQL is commonly used to write data-centric
programs to manipulate data in an Oracle database

Is This Answer Correct ?    16 Yes 2 No

What is pl/sql and what is it used for?..

Answer / akki julakanti

pl/sql is a procedural language
it is extension to sql introduced by oracle,
to perform operations over a database.
Here we follow some sequence of steps or programs.

Advantages:
1.supports conditional,looping,modularity
2.Better performance
3.Portability
4.Allow subprograms

Is This Answer Correct ?    7 Yes 2 No

What is pl/sql and what is it used for?..

Answer / ehsraka

It has an edge over the normal sql commands, as it
increases performance by pushing the bunch of sql commands
into engine in a single go.

Is This Answer Correct ?    8 Yes 4 No

What is pl/sql and what is it used for?..

Answer / durgaprasad sr

Actually why PL/SQl is existing when SQL is already there is...

To convert all the values present in a table to VARIABLES so that we can present the data on front end. untill and unless you convert them to variables you cant see the output on front end..

Is This Answer Correct ?    1 Yes 0 No

Post New Answer



More SQL PLSQL Interview Questions

What are the advantages of pl sql?

0 Answers  


What does subquery mean in sql?

0 Answers  


Why coalesce is used in sql?

0 Answers  


Can a select statement fire a trigger?

0 Answers  


Explain the working of foreign key?

0 Answers  






What are the events on which a database trigger can be based?

0 Answers  


which will default fire first  statement level trigger or row level trigger

2 Answers   Data Vision, Cap Gemini,


Can there be more than one function with a similar name in a pl/sql block?

0 Answers  


Explain the working of primary key?

0 Answers  


what are the authentication modes in sql server? How can it be changed? : Sql dba

0 Answers  


How do we accept inputs from user during runtime?

0 Answers  


Difference between aggregate function and analytical function?

3 Answers   Metric Stream,






Categories