![](https://img-blog.csdnimg.cn/20201014180756923.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 tr UNION SELEC...原创 2018-08-22 10:10:16 · 1972 阅读 · 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 · 4221 阅读 · 0 评论