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 ;

What is basic structure of pl sql?

500

---

What are the datatypes available in pl/sql ?

614

---

What is a temp table?

569

---

Explain the difference between drop and truncate commands in sql?

534

---

explain the difference between delete , truncate and drop commands? : Sql dba

548

---

---

What is difference between inner join and cross join?

522

---

how to enter numeric values as hex numbers? : Sql dba

570

---

What is ttitle and btitle?

576

---

Where is sql database stored?

520

---

What are the parameter modes supported by pl/sql?

534

---

what is the command used to fetch first 5 characters of the string? : Sql dba

1136

---

What is difference between rank () row_number () and dense_rank () in sql?

579

---

How long will it take to learn pl sql?

525

---

define sql delete statement ? : Sql dba

559

---

How global cursor can be declare with dynamic trigger ?

1748

---