Learn how to perform DML operations(INSERT, UPDATE,DELETE,SELECT) on PLSQL objects.
refer below URL
for plsql object and table reference and for insertion query scripts.
Example query to perform Update operation on plsql object
UPDATE Employee_TBL E
SET E.ADDRESS.zip = ‘516128’
WHERE E.EMP_ID = 1348;
Example query to perform delete operation on plsql object
DELETE
FROM Employee_TBL E
WHERE E.ADDRESS.zip = ‘516128’;
Example query to perform delete operation on plsql object
Example 1: Query table column with user defined type
SELECT E.ADDRESS.zip FROM STUDENT_TBL E;
Example 2: Selecting all columns
SELECT * FROM STUDENT_TBL;
Example 3: Selecting Composite column object
SELECT ADDRESS FROM STUDENT_TBL ;