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 do you define a foreign key?

746

---

How can we make an if statement within a select statement?

760

---

What is pl sql architecture?

715

---

What is minus?

776

---

GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?

2788

---

what are different types of collation sensitivity? : Sql dba

790

---

What is t sql used for?

752

---

What is a data manipulation language?

776

---

What is a unique key?

797

---

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

800

---

What is union?

832

---

What is meant by user defined function?

782

---

Is null operator in sql?

807

---

what does the t-sql command ident_current does? : Transact sql

757

---

Why procedure is used in sql?

778

---