mazhar

• Dec 12th, 2006

 

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..

shailendra_suman

• Feb 19th, 2007

 

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  /

Procedure created.

sachin s

• Apr 4th, 2007

 

IS Predicate comes with Create and AS comes with replace.