Untitled

CREATE OR REPLACE TYPE studentobj AS OBJECT (
    first_name   VARCHAR2(30),
    mid_name     VARCHAR2(30),
    last_name    VARCHAR2(30),
    nick_name    VARCHAR2(30)
);

CREATE OR REPLACE TYPE address AS OBJECT (
    country   VARCHAR2(30),
    province  VARCHAR2(30),
    city      VARCHAR2(30),
    zipcode   VARCHAR2(10),
    wardno    NUMBER,
    street    VARCHAR2(50)
);

CREATE OR REPLACE TYPE student_info AS OBJECT (
    name_info studentobj,
    addr_info address
);

CREATE TABLE students OF student_info;

INSERT INTO students VALUES (
    student_info(
        studentobj('Ram','Bahadur','Thapa','Ramu'),
        address('Nepal','Bagmati','Kathmandu','44600',5,'Putalisadak')
    )
);

INSERT INTO students VALUES (
    student_info(
        studentobj('Nisan','Chamling','Rai','Nisu'),
        address('Nepal','Bagmati','Kathmandu','44600',8,'Putalisadak')
    )
);

SELECT * FROM students;

SELECT 
    s.name_info.first_name,
    s.name_info.last_name,
    s.addr_info.city,
    s.addr_info.province
FROM students s;