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

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

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.

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..

Does google use sql?

0 Answers  

---

What is the difference between having clause and where clause?

0 Answers  

---

How to display the contents of a current record fetched in a reference cursor?

2 Answers  

---

how can we know the number of days between two given dates using mysql? : Sql dba

0 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---

---

how many ways we can we find the current date using mysql? : Sql dba

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

What is embedded sql in db2?

0 Answers  

---

What are joins in sql?

0 Answers  

---

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

how to retrive only second row from table?

31 Answers   IBM,

---

what is table? : Sql dba

0 Answers  

---