select
  'CREATE TABLE "'||t.owner||'"."'||t.table_name||'"'||chr(13)||chr(10)||
  '('||listagg('"'||c.column_name|| '" ' || c.data_type, ','||chr(13)||chr(10)) within group (order by c.column_id)||')' v
from
  (
    select 
      t.owner, t.table_name 
    from 
      all_tables t 
    where 
      t.owner = user and
      rownum <= 10
  ) t, all_tab_columns c
where 
  c.owner = t.owner and
  c.table_name = t.table_name
group by t.owner, t.table_name
order by t.owner, t.table_name

declare
  v clob;
begin
  for r in (
    select 
      t.table_name, t.owner
    from 
      all_tables t 
    where 
      t.owner = user and
      rownum <= 10
    order by t.table_name
  ) loop
    v:= dbms_metadata.get_ddl('TABLE', r.table_name, r.owner);
    dbms_output.put_line(v);
  end loop;
end;