Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE OR REPLACE TYPE MyUser AS OBJECT (
    id           NUMBER,
    name         VARCHAR2(100),
    email        VARCHAR2(100),
    phone_number VARCHAR2(15)
) NOT FINAL;
CREATE TABLE MyUser1 (
    user_info MyUser
);
INSERT INTO MyUser1 (user_info) 
VALUES (MyUser(1, 'Bedasa Wayessa', 'bedonafa@gmail.com', '0988736649'));
1 rows affected

SELECT mu1.user_info.name, mu1.user_info.email
FROM MyUser1 mu1


USER_INFO.NAME
USER_INFO.EMAIL


Bedasa Wayessa
bedonafa@gmail.com