Export entire schema definition (by username)

Export entire schema definition (by username)

select column_name as "Name"
     , nullable as "Null?"
     , concat(concat(concat(data_type,'('),data_length),')') as "Type"
  from user_tab_columns
 where table_name = 'EMPLOYEES';

TABLES STRUCTURE SEE

-------------------

set pagesize 0
set long 90000
set feedback off
set echo off
set heading ON
set lines 100

select
   dbms_metadata.GET_DDL(u.object_type,u.object_name,'HR')
from
   dba_objects u
where
   owner = 'HR';