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 run sql*plus commands that are stored in a local file?

761

---

Are null values same as that of zero or a blank space?

776

---

Which is faster truncate or drop?

836

---

How to Declare Fixed Length String Value In PL SQL

897

---

Where is sql database stored?

731

---

What are the operators in sql?

799

---

What is compound trigger?

778

---

What are sql injection vulnerabilities?

732

---

what are the authentication modes in sql server? : Sql dba

786

---

Explain the difference between cursor declared in procedures and cursors declared in the package specification?

804

---

Can we rollback after truncate?

805

---

Can we edit a view in sql?

755

---

What is latest version of sql?

788

---

Which are sql * plus commands?

761

---

How can we find duplicate records in a table?

713

---