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 delete command in sql?

549

---

what is transaction? : Sql dba

527

---

Can we alter stored procedure?

539

---

What are the different tcl commands in sql?

616

---

Is sql dba a good career? : SQL DBA

527

---

---

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

573

---

Why does sql need a server?

560

---

tell me about various levels of constraint. : Sql dba

526

---

Can a table contain multiple foreign key’s?

565

---

How do I run a script in sql developer?

485

---

What is the example of procedure?

509

---

Define commit?

542

---

what is oracle database ? : Sql dba

550

---

What is a dirty read sql?

472

---

what is log shipping? : Sql dba

603

---