RE: what is the difference between IS and AS keyword i...
IS keyword is the Synonym of AS. the difference is that when we use the keyworld IS then we must use the DECLARE Keyword to define the variables used in the procedure to follow... whereas if we use the keyword AS we need not to use the DECLARE keyword to define the variables directly we can start the BEGIN clause..
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 /
