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 full join in sql?

939

---

How to move files from one directory to another in pl sql?

1130

---

Explain the uses of a database trigger?

985

---

What are analytical functions in sql?

972

---

Which software is used for pl sql programming?

931

---

What is trigger in sql and its types?

992

---

How can you create an empty table from an existing table?

1012

---

What is 19 null in sql?

899

---

How do I remove sql developer from windows 10?

1016

---

Explain select statements in sql?

1003

---

How does a trigger work?

990

---

Can we rollback truncate?

946

---

What is the difference between functions, procedures, and packages in pl/sql?

974

---

What is cursor in pl sql with examples?

954

---

what are the advantages and disadvantages of cascading style sheets? : Sql dba

1007

---