user_constraints

来自「orale培训教材包括了所有的sql说明和实例」· 代码 · 共 10 行

ALTER TABLE plsql101_product ADD ( 
     CONSTRAINT reasonable_date3 CHECK(
          TO_CHAR(last_stock_date, 'YYYY-MM-DD') >= '2001-12-31'
          )
     )
;



select table_name from user_constraints where constraint_name=upper('reasonable_date3');