GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  RDBMS

 Print  |  
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  /

Procedure created.

     

 

Back To Question