Home » SQL & PL/SQL » SQL & PL/SQL » pl/sql procedure
pl/sql procedure [message #264306] Mon, 03 September 2007 00:04 Go to next message
ankitmodicse
Messages: 6
Registered: February 2007
Location: Bangalore
Junior Member

hi all

i have a doubt in writing procedure.

can u please tell me what is the diff in using is and as while wrinting a procedure.


create or replace procedure GET_PUBLISHER(VBOTITAL IN VARCHAR2,PUBLISHER_NAME OUT VARCHAR2,ADDRESS OUT VARCHAR2) IS

OR

create or replace procedure GET_PUBLISHER(VBOTITAL IN VARCHAR2,PUBLISHER_NAME OUT VARCHAR2,ADDRESS OUT VARCHAR2) AS
Re: pl/sql procedure [message #264308 is a reply to message #264306] Mon, 03 September 2007 00:07 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>can u please tell me what is the diff in using is and as while wrinting a procedure.

What has your testing demonstrated to yourself?
Re: pl/sql procedure [message #264315 is a reply to message #264306] Mon, 03 September 2007 00:26 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
what is the diff in using is and as while wrinting a procedure.


No difference. Anyone of these two you can use.
Re: pl/sql procedure [message #264317 is a reply to message #264308] Mon, 03 September 2007 00:27 Go to previous messageGo to next message
ankitmodicse
Messages: 6
Registered: February 2007
Location: Bangalore
Junior Member

nothing i used both its working fine.

but i want to know where i should use is and where as.


thanks
Re: pl/sql procedure [message #264318 is a reply to message #264306] Mon, 03 September 2007 00:31 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

It is your wish.Anyone you can use.
Previous Topic: How to Get Such resultset by count(),rollup .etc....?
Next Topic: Search the value in all fields
Goto Forum:
  


Current Time: Fri Dec 02 18:45:38 CST 2016

Total time taken to generate the page: 0.25696 seconds