What is the difference between “AS” and “IS” in an Oracle stored procedure?

by

None whatsover. They are synonyms supplied to make your code more readable:

FUNCTION f IS …

CREATE VIEW v AS SELECT …

More Related Contents:

  1. Place to store PL/SQL block [closed]
  2. Fetch Oracle table type from stored procedure using JDBC
  3. Passing an array of data as an input parameter to an Oracle procedure
  4. Oracle stored procedure with parameters for IN clause
  5. Get resultset from oracle stored procedure
  6. Functions vs procedures in Oracle
  7. oracle “table or view does not exist” from inside stored procedure
  8. Oracle SQL Developer: Show REFCURSOR Results in Grid?
  9. How to test an Oracle Stored Procedure with RefCursor return type?
  10. How to View Oracle Stored Procedure using SQLPlus?
  11. How to uninstall / completely remove Oracle 11g (client)?
  12. How can I set a custom date time format in Oracle SQL Developer?
  13. oracle convert unix epoch time to date
  14. Oracle trigger after insert or delete
  15. ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
  16. Difference between a user and a schema in Oracle?
  17. Base64 encoding and decoding in oracle
  18. What is the dual table in Oracle?
  19. pass array to oracle procedure
  20. Auto-increment in Oracle without using a trigger
  21. How to get primary key column in Oracle?
  22. How to create a user in Oracle 11g and grant permissions
  23. Trigger to enforce M-M relationship
  24. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  25. Oracle: how to INSERT if a row doesn’t exist
  26. Oracle: difference between max(id)+1 and sequence.nextval
  27. HikariCP: What database level timeouts should be considered to set maxLifetime for Oracle 11g
  28. Why cannot I create triggers on objects owned by SYS?
  29. automating rollback script oracle
  30. How do I get column datatype in Oracle with PL-SQL with low privileges?

Leave a Comment