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 the clause we need to add in function body to return variable?

761

---

What are types of exception?

688

---

what is a table in a database ? : Sql dba

750

---

What is pl sql block structure?

719

---

how to add a new column to an existing table in mysql? : Sql dba

777

---

---

what is oracle database ? : Sql dba

737

---

what is a tablespace? : Sql dba

766

---

Is sql developer case sensitive?

724

---

What is difference between joins and union?

747

---

Is primary key an index?

713

---

What is primary key sql?

713

---

What are local and global Indexes and where they are useful.

1136

---

What is a call statement? Explain with an example.

745

---

What are the sql commands?

792

---

how would concatenate strings in mysql? : Sql dba

742

---