Oracle Tip: Serialise data with ANYDATA columns

Friday Jul 30th 2004 by DatabaseJournal.com Staff
Share:

Learn how to back up entire tables - or more than one - using this powerful data type.

[From Builder UK]

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, but there are very few examples of this concept.

The article continues at http://uk.builder.com/architecture/db/0,39026552,39213578,00.htm

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved