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

How to write pl sql program in mysql command prompt?

0 Answers  


How do you write an index?

0 Answers  


What are all ddl commands?

0 Answers  


Is ms sql is free?

0 Answers  


How do I use google cloud in sql?

0 Answers  






What are the types of functions in sql?

0 Answers  


Difference between truncate, delete and drop commands?

0 Answers  


can we call a procedure from a function?

9 Answers   Mind Tree,


can we use out parameter in a function?Give an example.

4 Answers   TCS, Logica CMG,


what is log shipping? : Sql dba

0 Answers  


How do you get column names only for a table (sql server)?

0 Answers  


What is a pragma statement?

0 Answers  






Categories