Tag: technology

If errors occur during the compilation of a trigger, the trigger is still created.

If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_TRIGGERS data dictionary view to see the compilation errors.

If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL *Plus to see the compilation errors.

If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_ERRORS data dictionary view to see compilation errors.

USER_SOURCE

UTL_DEPTREE

USER_OBJECTS

DEPTREE_TEMPTAB

The rows are selected and ordered.

The validity of the SQL statement is established.

An area of memory is established to process the SQL statement.

The SQL statement is run and the number of rows processed is returned.

Trigger type

Trigger body

Trigger event

Trigger timing

USER_PROCEDURES

USER_PROCS

USER_OBJECTS

USER_PLSQL_UNITS

LEFT JOIN

RIGHT JOIN

FULL JOIN

SELF JOIN

True

False

True

False

Alternate Key

Foreign Key

Unique Key

Alias Key

COUNT()

GROUP BY()

SUM()

MAX()