Inserting Values:

Each object type has a system-defined constructor method, which is, a method that makes a new object according to the object type's specification. A name of the constructor method is the name of the object type. A constructor method is a function. Method returns the new object as its value. This is used to initialize the attributes with values.

Example

Data are inserted into the table EMPLOYEE_data by using CONSTRUCTOR METHOD

INSERT INTO employee _data VALUES ( 101, user_name (' Ramesh ', ' Sachin','Tendulkar'

) , user_date(04,05,98),10000)) ;

The possible queries which can be performed are:

For retrieve all the records from the table

SELECT         * FROM employee_data;      

SELECT         e.ename.fname, e.ename.lname           FROM employee_data e;

SELECT e.empno, e.dob.day FROM employee_data e;