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.

Report message to a moderator

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: 68675
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 09 02:21:11 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.