Answer Posted / madhuri

SQL is a structured query language used for various
operations such as retrieval,manipulation of data using
DML,DDL statements.

PL/SQL is programming language used to write various sql
statements together.Advantage of pl/sql over sql is,you can
write many sql statements within a pl/sql block.One more
advantage is subprogramming like procedures and functions.
We can write cursors for fetching number of records at a time.
And also packages and triggers.

Embedded sql are those statements which are written in host
programs like pro*c,java etc.

How to read xml file in oracle pl sql?

913

---

what is try_catch block in procedure

1748

---

What are different types of sql?

1190

---

How to display the records between two range in Oracle SQL Plus?

1147

---

How do you identify a primary key?

1063

---

What is clustered index sql?

984

---

What is indexing oracle sql?

1105

---

Can we delete column in sql?

1099

---

what is index? : Sql dba

1006

---

what is sql? : Sql dba

1030

---

What are stored procedures in mysql?

1019

---

How many developers work on postgresql?

983

---

How do sql triggers work?

1046

---

Does a user_objects view have an entry for a trigger?

1011

---

How to call shell script from pl sql procedure?

1280

---