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';
