CREATE OR REPLACE TYPE address AS OBJECT (
add1 varchar2(25),
add2 varchar2(25),
add3 varchar3(25)
);
CREATE TABLE customer (
cust_id NUMBER(10),
Cust_name varchar2(25),
addre address);
set describe depth all;
desc customer;
INSERT INTO customer
(cust_id, cust_name addre)
VALUES
(1, ‘Ramesh’, address('Plot No.25', 'Sidharth Colony, ‘Hyderabad'));
INSERT INTO customer
(cust_id, cust_name addre)
VALUES
(2, ‘Suresh’, address('Plot No.42', 'Sri Ram Nagar, ‘Bangalore'));
SELECT * FROM customer;
-- selective select
SELECT *
FROM customer p
WHERE p.addre.add3 = 'Hyderabad';