<<Previous Next>>
Oracle - What is composite data
type? - Feb 23, 2010 at 11:00 PM by Rajmeet
Ghai
What is composite data type?
A composite data type could be a record, table, nested table,
varray. This is so because all of them are composed of multiple data
types. Composite data types can be used to construct complex data
types fulfilling different requirements.
Oracle - What is composite data type? - Feb 07, 2010 at 14:20 PM
by Shuchi Gauri
What is composite data
type?
Composite data types are also known as
Collections .i.e RECORD, TABLE, NESTED TABLE, VARRAY.
Composite data types are of 2 types:
PL/SQL
RECORDS
PL/SQL Collections- Table, Varray, Nested Table
Explain the differences between char and varchar2 data types,
Explain BLOB, CLOB, NCLOB and BFILE, Explain ROWID in oracle, What
is a LOB data type?...........
Object data types are user defined data types. Both column and
row can represent an object type................
Both CLOB and NCLOB are used to store huge character data in the
database, CLOBs store single-byte character set data............
The BFILE datatype is used to store unstructured binary data
outside the database. The column of BFILE type stores file locator
that points the OS file which actually stores data............
|
