Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Common StatementsRSS Feeds

CREATE PROCEDURE

Posted By: Adalfreddo Fischer     Category: Oracle     Views: 3936

CREATE PROCEDURE with example

CREATE PROCEDURE

create procedure procedure_name
   [[(]@parameter_name
     datatype [(length) | (precision [, scale])
     [= default][output]
   [, @parameter_name
     datatype [(length) | (precision [, scale])
     [= default][output]]...[)]]
   [with recompile]
   as SQL_statements

CREATE PROCEDURE statement creates a new stored procedure in the database. This stored procedure can consist of SQL statements and can then be executed using the EXECUTE command. Stored procedures support input and output parameters passing and can return an integer value for status checking. 

  
Share: 

 
 
 

Didn't find what you were looking for? Find more on CREATE PROCEDURE Or get search suggestion and latest updates.

Adalfreddo Fischer
Adalfreddo Fischer author of CREATE PROCEDURE is from Frankfurt, Germany.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!