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 |
Give an example of Full Outer Join?
List the various privileges that a user can grant to another user?
What are stored procedures in mysql?
What is trigger with example?
Which are the different types of indexes in sql?
how to create a database in oracle?please gve anser with example
When you have to use a default "rollback to" savepoint of plvlog?
Explain what is a subquery ?
How do I tune a sql query?
How do you bind variables in pl sql?
How packaged procedures and functions are called from the following?
What is a cursor ? Why Cursor is required ?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)