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 ;

Why join is faster than subquery?

1159

---

Why do we use function in pl sql?

1114

---

What is sql profiler in oracle?

1160

---

Explain the difference between sql and mysql.

1112

---

what are different types of keys in sql?

1218

---

how to use regular expression in pattern match conditions? : Sql dba

1086

---

Can we group by two columns in sql?

1046

---

What is PL/SQL Records?

1253

---

What are the set operators in sql?

1136

---

What are inbuilt functions in sql?

1107

---

How to select random rows from a table?

1134

---

What is optimistic concurrency control? : Transact sql

1029

---

How run sql*plus commands that are stored in a local file?

1113

---

Is sql sequential or random?

1086

---

Can sql developer connect to db2?

1103

---