Oracle User's Table Name and with column Name

list of user's table
list of schema table


spool table.sql
select 'prompt '||'Table Name =>'||table_name ||'
desc '||owner||'.'||table_name from dba_tables where owner='XYZ' order by table_name
spool off

@table.sql