Answer / rajesh

Declare
begin
exception
end;

Answer / vasan

Declare (Optional)
begin (Mandatory)
exception(Optional)
end; (Mandatory)

Answer / dinesh mishra

Header (named module only)
Declaration (IS)
Execution (BEGIN)
Exception
END;

Answer / menan

declaration part;
begin
executable part;
exception handling;
end;

Answer / 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 ;

Answer / kannan

# 4

Declare (Optional)
begin (Mandatory)
exception(Optional)
end; (Mandatory)

What is difference between Procedures and Functions ?

6 Answers   Hi Caliber IT,

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

What is difference between hql and native sql?

0 Answers  

What is sql constant?

0 Answers  

How does sql profiler work?

0 Answers  

Explain the components of sql?

0 Answers  

Explain how to use transactions efficiently : transact sql

0 Answers  

What does a pl/sql package consist of?

0 Answers  

What is a recursive join sql?

0 Answers  

Is sql harder than python?

0 Answers  

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

0 Answers  

How do I clear the screen in sql plus?

0 Answers