Tuesday, June 06, 2006

New Data Type in Oracle 9i which allows virtually store any data type

New Data Type in Oracle 9i which allows virtually store any data type
ANYDATA
ANYDATASET
Oracle version 9 introduced interesting new data types, which allow developers to declare a variable that can contain any type of data. The data types are ANYDATA for a single item, ANYDATASET for a TABLE or VARRAY of data, and ANYTYPE, which describes the type of data stored in ANYDATA or ANYDATASET variables and columns. These data types are important for processing XML data stored in the database, or for Advanced Queues. The documentation mentions that the ANYDATA data type can be used to serialize objects as well.


Ritesh Kumar Kesharwani
Cell : 91-9890901287



How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates.