Oracle PL/SQL - What Is a Procedure
Interview Question Database For Software Developers
|
|
| What Is a Procedure | | What Is a Procedure? - Oracle DBA FAQ - Understanding PL/SQL Language Basics | | By: FYIcenter.com | A procedure is a named program unit. It consists of three parts:
- Declaration Part - Defining the procedure name, calling parameters, local variables and local procedures.
Declaration part is required.
- Execution Part - Defining execution logic with executable statements. Execution part is required.
- Exception Part - Defining error handling logics. Exception part is optional.
Here how a complete procedure should look like:
PROCEDURE name (parameter_1, parameter_2) AS
-- Declaration statements
BEGIN
-- Executable statements
EXCEPTION
-- Error handling statements
END;
| | ID: 716 | Rank: 1074 | Votes: 0 | Views: 34 | Submitted: 20070430 |
1088
:-) | | What Is an Anonymous Block | | What Is an Anonymous Block? - Oracle DBA FAQ - Understanding PL/SQL Language Basics... | | Submitted: 20070430 |
|
1074
:-) | | What Is a Procedure | | What Is a Procedure? - Oracle DBA FAQ - Understanding PL/SQL Language Basics... | | Submitted: 20070430 |
|
1078
:-) | | What Is a Function | | What Is a Function? - Oracle DBA FAQ - Understanding PL/SQL Language Basics... | | Submitted: 20070430 |
|
Copyright © 2009 FYIcenter.com
All rights in the contents of this Website are reserved by the individual author.
No part of the contents may be reproduced in any form without author's permission.
|
|
|
Atom feed
List view