Oracle PL/SQL - What Is a Procedure
Interview Question Database For Software Developers
|
|
| What Is a Procedure | | What Is a Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions | | 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: 774 | Rank: 1097 | Votes: 0 | Views: 53 | Submitted: 20070426 |
1097
:-) | | What Is a Procedure | | What Is a Procedure? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions... | | Submitted: 20070426 |
|
1096
:-) | | What Is a Function | | What Is a Function? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and Functions... | | Submitted: 20070426 |
|
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