What is pl/sql and what is it used for?
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.
Advantages:
1.supports conditional,looping,modularity
2.Better performance
3.Portability
4.Allow subprograms
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 |
how can we repair a mysql table? : Sql dba
What cursor type do you use to retrieve multiple recordsets?
17 Answers Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,
How to retrieve Duplicate Rows only in a Table? Suppose if a Table Name is "Education". It consists of multiple columns. Then if we insert rows into this table with duplicate records then how can we retrieve only duplicate records from that table?
28 Answers Alps, Aricent, Bank Of America, Wipro,
what are the non-standard sql commands supported by 'mysql'? : Sql dba
What is Temp Table and type of temp table?
when MSQL8.0 is in market
What is Highwatermark?
I i have 2 tables A & B ,A contains 10 records B contains 20 records ,what w'll be the o/p if we perform equijoin,outer join,right outer join,left outer join,full outer join,cross join seperately Can anyone help on this?
What do you mean by field in sql?
what is the difference between nested subquery and correlated subquery?
How do you explain an index number?
What is bind variable in pl sql?