Question: what is the difference between IS and AS keyword in procedures, and also tell me the diff between Restricted and Unretsricted Procedure
February 02, 2007 08:47:28
#2
shailendra_suman
Member Since: Visitor Total Comments: N/A
RE: what is the difference between IS and AS keyword i...
I don't think there is any difference. I tried both and worked fine SQL> SQL> create procedure testing is 2 3 begin 4 5 dbms_output.put_line('Testing for IS Syntax'); 6 7 end; 8 9 /
Procedure created.
SQL> drop procedure testing ;
Procedure dropped.
SQL> create procedure testing as 2 3 begin 4 5 dbms_output.put_line('Testing for AS Syntax'); 6 7 end; 8 9 /