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 sqlservr exe?

975

---

What types of commands can be executed in sql*plus?

1109

---

How to sort the rows in sql.

1075

---

What is sqlcommand?

1026

---

What's the difference between inner join and left join?

999

---

How is debugging done?

975

---

What is Difference Between Unique and Primary Key Constraints?

1105

---

Explain the structure of pl/sql in brief.

1093

---

What are the syntax and use of the coalesce function?

1202

---

Can we use ddl commands in pl sql?

1162

---

What is natural join in sql?

989

---

What are the two types of exceptions.

1167

---

What is the difference between numeric and autonumber?

996

---

Is record in pl sql?

971

---

what is commit? : Sql dba

1071

---