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

Answer

 Given a loose object type:

CREATE TYPE someRecordType AS OBJECT
(
   SomeCol VARCHAR2(12 BYTE)
);

You can create a loose Table type of this object type with either AS or IS

CREATE OR REPLACE TYPE someTableType
        IS {or AS} TABLE OF someRecordType;

However, if you create this same table type within a package, you must use IS:

CREATE OR REPLACE PACKAGE SomePackage IS
    TYPE packageTableType IS TABLE OF someRecordType;
END SomePackage;


All oracle Questions

Ask your interview questions on oracle

Write Your comment or Questions if you want the answers on oracle from oracle Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---