<<Previous Next>>
Oracle - What is object data
type in oracle? - Feb 07, 2010 at 14:20 PM by Shuchi
Gauri
What is object data type in oracle?
New/User defined objects can be created from
any database built in types or by their combinations. It makes it
easier to work with complex data like images, media (audio/video).
An object types is just an abstraction of the real world entities.
An object has:
Name
Attributes
Methods
Example:
Create type
MyName as object (first varchar2(20), second varchar2(20));
Now you can use this datatype while defining a
table below:
Create table Emp (empno number(5),Name
MyName);
One can access the Atributes as Emp.Name.First and
Emp.Name.Second
Oracle - What is object data type in oracle? - April 10, 2009
at 11:00 AM
What is object data type in
oracle?
Object data type is created using object
type in oracle. The object data type can only be created using SQL
data type such as Number, Varchar 2, Date etc. PL/SQL types can’t be
used to create object data type.
Example
Create or Replace Type EMP as object
(
Id Number (5)
Name
varchar2(30)
);
Also read
What is composite data type? Explain the types of composite data
type...............
Oracle stores information in the form of tables. For eg you can
have a table named as climate in which you can store information
about the climate of a place in the form of columns...........
Define Exceptions in PL/SQL, Explain how to define and raise
exceptions in PL/SQL............
An extent is stored some specific information. This information
is stored using specific number of adjoining data blocks. A
collection of extent is called as a segment stored in the same
tablespace..............
|
