Answer Posted / shekharjchandra

The basic structure of PL/SQL is

1. Header Section
2. Declaration Section
3. Executable Section
4. Exception Section

Eg:-

<<This_is_Header>>
DECLARE
a NUMBER ;
BEGIN
-- Code goes here
NULL;
EXCEPTION
WHEN OTHERS THEN
NULL ;
END ;

How to find 3rd highest salary of an employee from the employee table in sql?

655

---

The select into statement is most often used to create backup copies of tables or for archiving records?

666

---

What is sql catalog?

665

---

What is assignment operator in pl sql?

672

---

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

1646

---

---

What are the packages in pl sql?

658

---

What are conditional predicates?

692

---

How to set up sql*plus output format in oracle?

690

---

Can we use having without group by in sql?

633

---

What is rank () in sql?

617

---

What are the topics in pl sql?

604

---

Which is the correct statement about truncate and delete?

621

---

How do you optimize a stored procedure in sql?

581

---

What are the types of triggers in sql?

591

---

what is a tablespace? : Sql dba

651

---