Tag: databases

Use a drop procedure statement to drop a standalone procedure.

Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package specification.

Use a drop procedure statement to drop a procedure that is part of a package. Then recompile the package body.

For faster removal and re-creation, do not use a drop procedure statement. Instead, recompile the procedure using the alter procedure statement with the REUSE SETTINGS clause.

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

a record

a field

a table

an entity

section name, age

name

undergraduate

name, class name

major, gender

Visio

ERwin

ER/Studio

Data Builder

empowER

Design logical data systems

Design physical storage system

Define data entities relevant to the enterprise

All of the above