JRE 1.8.0_171/172 Certified with Oracle EBS 12.1 and 12.2 - Java Runtime Environment 1.8.0_171 (a.k.a. JRE 8u171-b11) and JRE 1.8.0_172 (a.k.a. JRE 8u172-b11) and later updates on the JRE 8 codeline are now certifie...
Acum 16 ore
$sqlplus / as sysdba sqlplus> alter user APEX_030200 grant connect through scott; User altered.
ALTER TABLEstatement with the
EXCEPTIONSoption in the
EXCEPTIONSoption places the rowid, table owner, table name, and constraint name of all exception rows into a specified table.
EXCEPTIONSoption of the
ENABLEclause before enabling the constraint. You can create an exception table by executing the
UTLEXCPT.SQLscript or the
EXCEPTIONS. You can create additional exceptions tables with different names by modifying and resubmitting the script.
PRIMARY KEYof the
depttable, and if exceptions exist, information is inserted into a table named
ALTER TABLE dept ENABLE PRIMARY KEY EXCEPTIONS INTO EXCEPTIONS;
depttable and the name of the
PRIMARY KEYconstraint on
sys_c00610, then the following query will display those exceptions:
SELECT * FROM EXCEPTIONS;