Answers were Sorted based on User's Feedback
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|
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.
|Is This Answer Correct ?||7 Yes||2 No|
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|
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|
What are the advantages of pl sql?
What does subquery mean in sql?
Why coalesce is used in sql?
Can a select statement fire a trigger?
Explain the working of foreign key?
What are the events on which a database trigger can be based?
which will default fire first statement level trigger or row level trigger
Can there be more than one function with a similar name in a pl/sql block?
Explain the working of primary key?
what are the authentication modes in sql server? How can it be changed? : Sql dba
How do we accept inputs from user during runtime?
Difference between aggregate function and analytical function?