Interested to Buy Any Domain ? << Click Here >> for more details...
What is pl/sql and what is it used for?
- 4 Answers
- 15785 Views
- I also Faced
- E-Mail Answers
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 |
In a table i have columns A,B,C and i have a composite index on columns A,B if so will the following query uses index or not? SELECT sal,name FROM <table_name> WHERE A=<value> AND B=<value> AND C=<value>;
What is sql and how does it work?
What are the two parts of design view?
How do I know if I have sql express or standard?
what is the output of this query selet * from employee where 1=2 ??
how many tables will create when we create table, what are they? : Sql dba
How to load data with sql*loader?
What are the operators in sql?
What does select top 1 do in sql?
how to dump a table to a file with 'mysqldump'? : Sql dba
Two Methods of retrieving SQL?
7 Answers Atiric Software, Microsoft, Oracle, TCS, Wipro,
What is normalization in a database?
-
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)
