Syantax to create a stored procedure.

Posted by Rajni.Shekhar on 4/13/2012 | Category: Sql Server Interview questions | Views: 3335 | 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

Bookmark It

< Previous : What is Coalesce?

Next > : What is syntax to execute a stored procedure?

Posted by: Easwaran on: 9/3/2012 | Points: 10

To modify SP we should use ALTER not REPLACE.

More Interview Questions by Rajni.Shekhar

Latest Interview Questions