得到對錶操作的指令碼（可作為參考）

得到對錶操作的指令碼（可作為參考）[@more@]

--使約束失效的指令碼
set feedback off
set pagesize 0
spool d:disableconstraint.sql
select 'alter table ' || table_name || chr(10) || ' disable constraint ' ||
constraint_name || ';' obj
from user_constraints
where constraint_type in ('R');
spool off
--啟用約束的指令碼
spool d:enableconstraint.sql
select 'alter table ' || table_name || chr(10) || ' enable constraint ' ||
constraint_name || ';' obj
from user_constraints
where constraint_type in ('R');
spool off
--清空表的指令碼
spool d:truncatetable.sql
select 'truncate table ' || table_name || ';' obj
from user_tables;
spool off
set feedback on
set pagesize 14

create or replace procedure sp_getdefaultvalue is
/*
得到修改表的列的預設值語句.
*/
begin
for rec in (select * from user_tab_columns where data_default is not null)
loop
dbms_output.put_line('alter table '||rec.table_name||' modify '||rec.column_name||' default '||rec.data_default||';');
end loop ;
end sp_getdefaultvalue;
/