Home » RDBMS Server » Server Administration » IS and AS
IS and AS [message #321679] Wed, 21 May 2008 00:56 Go to next message
ORAGENASHOK
Messages: 240
Registered: June 2006
Location: Chennai
Senior Member
Can anyone give details different b/w IS and AS in pl/sql procedure.
Re: IS and AS [message #321682 is a reply to message #321679] Wed, 21 May 2008 01:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68704
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None.

Regards
Michel
Re: IS and AS [message #321703 is a reply to message #321679] Wed, 21 May 2008 01:55 Go to previous message
msmallya
Messages: 66
Registered: March 2008
Location: AHMEDABAD, GUJARAT
Member
IS you will use while declaring a cursor like
cursor cur1 is

AS/IS used in procedure/function like
create or replace procedure ....as or
create or replace procedure ....is

Regards,

MSMallya
Previous Topic: Related to Cursor
Next Topic: recreate control file: do i need to create temp file after i mount the database
Goto Forum:
  


Current Time: Mon Nov 04 05:53:30 CST 2024