Syantax to create a stored procedure.

 Posted by Rajni.Shekhar on 4/13/2012 | Category: Sql Server Interview questions | Views: 1593 | Points: 40
Answer:

Create a stored procedure using following lines of code.

Create or Replace Procedure sp_proc_name

(param1 varchar2(20), param2 varchar2(20))
as
begin
select * from tableName
end;


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Easwaran on: 9/3/2012 | Points: 10
To modify SP we should use ALTER not REPLACE.

Login to post response