metal

 Profile Answers by metal 

• Jan 31st, 2010

 

CREATE or REPLACE PROCEDURE proc_test

(name IN varchar2 DEFAULT 'Me' )

AS

BEGIN

dbms_output.put_line('My name is proc_test ' || name);

END;

SQL> exec proc_test('hello');

My name is proc_test hello

SQL> exec proc_test();

My name is proc_test Me

nisargkothari

 Profile Answers by nisargkothari 

• Sep 16th, 2010

 

create procedure sp_test
@param1 INT ,
@param2 INT= value

as

select * from testtable1 where value1 = @param1 and value2 = @param2

Priyanka Roy

• Dec 6th, 2017

 

DECLARE
@Parameter1 varchar(max)=PRIYANKA

Code
DECLARE


@Parameter1 varchar(max)=PRIYANKA