<< GETDATE() equivelant in Oracle | How to find all tables with a specific column name in MS SQL >>

Creating stored procedures in Oracle/PLSQL

The syntax for a procedure is:

CREATE [OR REPLACE] PROCEDURE procedure_name
    [ (parameter [,parameter]) ]
IS
    [declaration_section]
BEGIN
    executable_section
[EXCEPTION
    exception_section]
END [procedure_name];

Original Post: http://www.techonthenet.com/oracle/procedures.php

fa8e5dff-41df-4cf0-9f7b-472c86b9e82e|0|.0

Tags: Oracle, PLSQL, procedures

Categories: Databases

Posted by wizgod on Thursday, August 26, 2010 8:21 PM

E-mail | Kick it! | DZone it! | del.icio.us

Permalink | Comments (1) | Post RSS RSS comment feed

Insert into table using a stored procedure.Insert into table using a stored procedure.Getting "The password does not meet the password policy requirements" in Windows Server 2008 when creating new userIf you don't want to force complex passwords change the various settings in the Password Policy by: ...Create a table in Oracle stored procedure or functionUse the following: EXECUTE IMMEDIATE 'CREATE TABLE MyTable (id NUMBER)';

Comments

Prep Material

Wednesday, February 15, 2012 12:19 PM

I collected a lot of interesting things from your blog especially its discussion. I believe I’m not alone having all the enjoyment here! keep up the great work.

Add comment

Name*
E-mail*
Website
Country Country flag

b i u quote

Comment
Preview

Notify me when new comments are added

Byte My Data

A personal collection of advice and solutions I've used.

Month List

Feedjit

About the author

Creating stored procedures in Oracle/PLSQL

Byte My Data

A personal collection of advice and solutions I've used.

Month List

Feedjit

About the author

Tag cloud

Blogroll

Creating stored procedures in Oracle/PLSQL