1)connect the oracle with user "dev" 2)set pagesize 0 3)spool desc.sql 4)select 'desc '||tname||';' from tab where tabtype='TABLE'; 5)spool off;then exec the desc.sql in sqlplus,all will done.
用触发器,例如如下: create or replace trigger name_tri before delete on 父表 for each row begin delete from 子表 where id=:new.id; end; /
erwin pl/sql developer toad object brower
清空表用truncate table table_name最方便,因为不使用回滚段。
1)connect the oracle with user "dev" 2)set pagesize 0 3)spool truncate.sql 4)select 'truncate table '||tname||';' from tab where tabtype='TABLE'; 5)spool off;然后在用编辑工具打开truncate.sql,将你不要清空的表的行删除,在sqlplus上执行truncate.sql就OK了
2)set pagesize 0
3)spool desc.sql
4)select 'desc '||tname||';' from tab where tabtype='TABLE';
5)spool off;then exec the desc.sql in sqlplus,all will done.
create or replace trigger name_tri
before delete on 父表
for each row
begin
delete from 子表 where id=:new.id;
end;
/
pl/sql developer
toad
object brower
2)set pagesize 0
3)spool truncate.sql
4)select 'truncate table '||tname||';' from tab where tabtype='TABLE';
5)spool off;然后在用编辑工具打开truncate.sql,将你不要清空的表的行删除,在sqlplus上执行truncate.sql就OK了
这到是个办法阿
哪有没有办法在delphi中这样实现呢??