begin for rec in (select table_name from user_tables) loop dbms_output.put_line(dbms_metadata.get_ddl('TABLE', rec.table_name)); end loop; end;如果需要其他index, view等,稍微改下, 例如index改成begin for rec in (select index_name from user_indexes) loop dbms_output.put_line(dbms_metadata.get_ddl('INDEX', rec.index_name)); end loop; end;
for rec in (select table_name from user_tables)
loop
dbms_output.put_line(dbms_metadata.get_ddl('TABLE', rec.table_name));
end loop;
end;如果需要其他index, view等,稍微改下,
例如index改成begin
for rec in (select index_name from user_indexes)
loop
dbms_output.put_line(dbms_metadata.get_ddl('INDEX', rec.index_name));
end loop;
end;