Answer Posted / madhuri

sql is a structured query language which executes one sql
statement at a time where as pl/sql is a programming
language which embedd set of sql statements as a block and
executes it.Main advantage of pl/sql over sql is,we can use
control structures,cursors,subprograms and exception
handling in this case.

Is oracle sql free?

726

---

how to use like conditions? : Sql dba

768

---

What is scope and visibility in PL/SQL?

766

---

What is set serveroutput on?

835

---

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

2172

---

---

Does group by remove duplicates?

750

---

What is a dirty read sql?

707

---

What is the difference between nvl function, ifnull function, and isnull function?

787

---

How do you remove duplicates without using distinct in sql?

689

---

What is pl sql script?

726

---

What is the need of merge statement?

754

---

How do I copy a table in sql?

686

---

Can function return multiple values in sql?

723

---

Why do we need databases?

725

---

What operators deal with null?

809

---