oracle
夭荆
这个作者很懒,什么都没留下…
展开
-
oracle 关于 union+order by+ rownum分页问题
SELECT *FROM ( SELECT TMP_PAGE.*, ROWNUM ROW_ID FROM ( SELECT * FROM(SELECT TR."ID", TR."NAME",TR.BANJI FROM T_REGISTER trUNIONSELEC...原创 2018-08-22 10:10:16 · 2008 阅读 · 0 评论 -
ORA-02292:integrity constraint(xx) violated - child record found 外键关联,无法删除记录
当我们删除 有外键的数据的时候 oracle 都会提示:ORA-02292:integrity constraint(xx) violated - child record found 第一步:让主键失效:alter table table_name disable primary key cascade;第二步:删除数据:delete from table_name where id...原创 2018-12-10 14:50:37 · 4246 阅读 · 0 评论