changeset 2218 | 39e18e1912b7 |
parent 2217 | 3005f2860e3c |
child 2219 | f991bbf12a59 |
--- a/oracle.rst Mon Jan 22 19:19:51 2018 +0200 +++ b/oracle.rst Wed Jan 24 16:42:34 2018 +0200 @@ -159,7 +159,7 @@ select * from SYS.USER_CONSTRAINTS cons join SYS.USER_CONSTRAINTS rcons on rcons.CONSTRAINT_NAME = cons.R_CONSTRAINT_NAME - where cons.CONSTRAINT_TYPE = 'R' and rcons.TABLE_NAME 'TBL_NAME'; + where cons.CONSTRAINT_TYPE = 'R' and rcons.TABLE_NAME = 'TBL_NAME'; select * from SYS.USER_CONSTRAINTS cons join SYS.USER_CONSTRAINTS rcons on rcons.CONSTRAINT_NAME = cons.R_CONSTRAINT_NAME