describe SVLOCALSHOPS; describe SVPRODGOODSART;
SQL> describe supermag.SVLOCALSHOPS; имя пусто? тип ----------------------------------------- -------- --------------------- ID NOT NULL NUMBER(10) NAME NOT NULL VARCHAR2(255) IDCLASS NOT NULL NUMBER(10) ACCEPTED NOT NULL CHAR(1) PRTY NOT NULL NUMBER(5) FLAGS NOT NULL NUMBER(10) LOCTYPE NOT NULL NUMBER(5) PARENTLOC NUMBER(10) RGNID NOT NULL NUMBER(10) ADDRESS VARCHAR2(255) TEL VARCHAR2(40) FAX VARCHAR2(40) COMMENTARY VARCHAR2(255) ORDERALG NOT NULL VARCHAR2(255) CARDTYPE NUMBER(10) FORMATID NUMBER(10) PRICINGMETHOD NOT NULL NUMBER(5) SUGGESTORDERALG NOT NULL VARCHAR2(50) FLOORSPACE NUMBER(14,4) GLN VARCHAR2(13) SQL> describe supermag.SVPRODGOODSART; имя пусто? тип ----------------------------------------- -------- --------------- STORELOC NOT NULL NUMBER(10) ID NOT NULL NUMBER(10) ARTICLE NOT NULL VARCHAR2(50) QUANTITY NOT NULL NUMBER(14,3) NAME VARCHAR2(255) UNITNAME VARCHAR2(20) INCOMINGQUANTITY NOT NULL NUMBER(14,3) ISSUEQUANTITY NOT NULL NUMBER(14,3) AVAILABLEQUANTITY NUMBER RETURNQUANTITY NOT NULL NUMBER(14,3) WASTEQUANTITY NUMBER
SQL> describe supermag.SVLOCALSHOPS; имя пусто? тип ----------------------------------------- -------- ---------------- ID NOT NULL NUMBER(10) NAME NOT NULL VARCHAR2(255) IDCLASS NOT NULL NUMBER(10) ACCEPTED NOT NULL CHAR(1) PRTY NOT NULL NUMBER(5) FLAGS NOT NULL NUMBER(10) LOCTYPE NOT NULL NUMBER(5) PARENTLOC NUMBER(10) RGNID NOT NULL NUMBER(10) ADDRESS VARCHAR2(255) TEL VARCHAR2(40) FAX VARCHAR2(40) COMMENTARY VARCHAR2(255) ORDERALG NOT NULL VARCHAR2(255) CARDTYPE NUMBER(10) FORMATID NUMBER(10) PRICINGMETHOD NOT NULL NUMBER(5) SUGGESTORDERALG NOT NULL VARCHAR2(50) FLOORSPACE NUMBER(14,4) GLN VARCHAR2(13) SQL> describe supermag.SVPRODGOODSART; имя пусто? тип ----------------------------------------- -------- ---------------------------- STORELOC NOT NULL NUMBER(10) ID NOT NULL NUMBER(10) ARTICLE NOT NULL VARCHAR2(50) QUANTITY NOT NULL NUMBER(14,3) NAME VARCHAR2(255) UNITNAME VARCHAR2(20) INCOMINGQUANTITY NOT NULL NUMBER(14,3) ISSUEQUANTITY NOT NULL NUMBER(14,3) AVAILABLEQUANTITY NUMBER RETURNQUANTITY NOT NULL NUMBER(14,3) WASTEQUANTITY NUMBER
select * from all_constraints t where t.constraint_name='SYS_C0011218'
SQL> select * from all_constraints t where t.constraint_name='SYS_C0011218';
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
SUPERMAG SYS_C0011218 O
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
SVLOCALSHOPS
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
ENABLED
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
NOT DEFERRABLE IMMEDIATE NOT VALIDATED GENERATED NAME 06.04.10
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
-------------- SQL> select * from all_constraints t where t.constraint_name='SYS_C0011219';
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
SUPERMAG SYS_C0011219 O
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
SVPRODGOODSART
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
ENABLED
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
NOT DEFERRABLE IMMEDIATE NOT VALIDATED GENERATED NAME 06.04.10
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
--------------
OWNER CONSTRAINT_NAME C
------------------------------ ------------------------------ -
TABLE_NAME
------------------------------
SEARCH_CONDITION
--------------------------------------------------------------------------------
R_OWNER R_CONSTRAINT_NAME DELETE_RU STATUS
------------------------------ ------------------------------ --------- --------
DEFERRABLE DEFERRED VALIDATED GENERATED BAD RELY LAST_CHA
-------------- --------- ------------- -------------- --- ---- --------
INDEX_OWNER INDEX_NAME INVALID
------------------------------ ------------------------------ -------
VIEW_RELATED
-------------- SQL> select * from all_constraints t where t.constraint_name='SYS_C0011218'; строки не выбраны SQL> select * from all_constraints t where t.constraint_name='SYS_C0011219'; строки не выбраны