Oracle PL/SQL - Posted
on August 28, 2008 at 15:00 PM by Amit Satpute
Explain the advantages of PL/SQL.
Answer
PL/SQL is a transaction processing language that offers the following
advantages:
-
support for SQL - SQL is flexible, powerful and easy to learn.
-
support for object-oriented programming
-
better performance - with PL/SQL, an entire block of statements can be sent to
Oracle at one time.
-
higher productivity - PL/SQL increases productivity by enabling use of better
tools.
-
full portability - PL/SQL are portable to any operating system and platform on
which Oracle runs.
-
tight integration with Oracle
-
security PL/SQL can achieve data abstraction, access control.
Explain block structure of PL/SQL.
Answer
DECLARE
--------declarations
BEGIN
--------statements
EXCEPTIONS
--------handlers
END;
The order of the parts is quite logical:
First comes the declarative part, in which items can be declared.
Items can be manipulated in the executable part.
Exceptions raised during can be handled in the exception-handling part.
The answers to following questions will be made available soon. Keep
visiting.
Define PL/SQL.
Explain each section of PL/SQL with an example, i.e. Declaration, Executable
commands, Exception handling.
Explain the condition logic with an example, i.e. if, else, elsif and case
command.
What is Goto statement? Explain its uses with an example.
|