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

Why do we use joins?

0 Answers  

---

TABLE A TABLE B EMPNO ENAME EMPNO ENAME 1 A 1 A 2 B 2 B 3 C 3 C 4 D 4 D 5 E 5 E 6 F 7 G HOW TO GET THE UNMATCHED RECORDS IN SQL QUERY?

10 Answers   Satyam,

---

What are sql built in functions?

0 Answers  

---

What is the most restrictive isolation level? : Transact sql

0 Answers  

---

How do I pipe the output of one isql to another?

0 Answers  

---

What is example of database?

0 Answers  

---

sql query to get zero records from a table having n no of records

8 Answers   CTS,

---

What is 19 null in sql?

0 Answers  

---

What are basic techniques of indexing?

0 Answers  

---

How long does it take to learn pl sql?

0 Answers  

---

Can you create a table with Primary Key not as the clustered index.

2 Answers   CGI,

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

0 Answers   Wipro,

---