HI EXPERT

select TABLE_NAME, column_name,data_type from user_tab_cols;

select TABLE_NAME, column_name,data_type from RND_TABLES;

create table rnd_tables(TABLE_NAME varchar2(30),column_name varchar2(30));

insert into rnd_tables values('EMPLOYEES','id');

insert into rnd_tables values('EMPLOYEES','FNAME');

insert into rnd_tables values('EMPLOYEES','LNAME');

insert into rnd_tables values('EMPLOYEES','DOB');

insert into rnd_tables values('EMPLOYEES','email');

insert into rnd_tables values('EMPLOYEES','phone');

insert into rnd_tables values('EMPLOYEES','location');

insert into rnd_tables values('DEPT','DeptID');

insert into rnd_tables values('DEPT','DNAME');

insert into rnd_tables values('DEPT','DEPTCODE');