Toad Data Modeler - HTML Report

MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES -> MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTY_TRG

General Info

Caption	MD_ADDITIONAL_PROPERTY_TRG
Entity Name	MIGRATION_WORKBENCH.MD_ADDITIONAL_PROPERTIES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_APPLICATIONFILES -> MIGRATION_WORKBENCH.INS_APPLICATIONFILE_TRG

General Info

Caption	INS_APPLICATIONFILE_TRG
Entity Name	MIGRATION_WORKBENCH.MD_APPLICATIONFILES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_APPLICATIONS -> MIGRATION_WORKBENCH.INS_APPLICATION_TRG

General Info

Caption	INS_APPLICATION_TRG
Entity Name	MIGRATION_WORKBENCH.MD_APPLICATIONS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_CATALOGS -> MIGRATION_WORKBENCH.MD_CATALOGS_TRG

General Info

Caption	MD_CATALOGS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_CATALOGS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_COLUMNS -> MIGRATION_WORKBENCH.MD_COLUMNS_TRG

General Info

Caption	MD_COLUMNS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_COLUMNS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_CONNECTIONS -> MIGRATION_WORKBENCH.MD_CONNECTIONS_TRG

General Info

Caption	MD_CONNECTIONS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_CONNECTIONS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS -> MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS_TRG

General Info

Caption	MD_CONSTRAINT_DETAILS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_CONSTRAINT_DETAILS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_CONSTRAINTS -> MIGRATION_WORKBENCH.MD_CONSTRAINTS_TRG

General Info

Caption	MD_CONSTRAINTS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_CONSTRAINTS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_DERIVATIVES -> MIGRATION_WORKBENCH.MD_DERIVATIVES_TRG

General Info

Caption	MD_DERIVATIVES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_DERIVATIVES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS -> MIGRATION_WORKBENCH.INS_FILE_ARTIFACT_TRG

General Info

Caption	INS_FILE_ARTIFACT_TRG
Entity Name	MIGRATION_WORKBENCH.MD_FILE_ARTIFACTS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_GROUP_MEMBERS -> MIGRATION_WORKBENCH.MD_GROUP_MEMBERS_TRG

General Info

Caption	MD_GROUP_MEMBERS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_GROUP_MEMBERS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES -> MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES_TRG

General Info

Caption	MD_GROUP_PRIVILEGES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_GROUP_PRIVILEGES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_GROUPS -> MIGRATION_WORKBENCH.MD_GROUPS_TRG

General Info

Caption	MD_GROUPS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_GROUPS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_INDEX_DETAILS -> MIGRATION_WORKBENCH.MD_INDEX_DETAILS_TRG

General Info

Caption	MD_INDEX_DETAILS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_INDEX_DETAILS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_INDEXES -> MIGRATION_WORKBENCH.MD_INDEXES_TRG

General Info

Caption	MD_INDEXES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_INDEXES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY -> MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY_TRG

General Info

Caption	MD_MIGR_DEPENDENCY_TRG
Entity Name	MIGRATION_WORKBENCH.MD_MIGR_DEPENDENCY

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_MIGR_PARAMETER -> MIGRATION_WORKBENCH.MD_MIGR_PARAMETER_TRG

General Info

Caption	MD_MIGR_PARAMETER_TRG
Entity Name	MIGRATION_WORKBENCH.MD_MIGR_PARAMETER

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP -> MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP_TRG

General Info

Caption	MD_MIGR_WEAKDEP_TRG
Entity Name	MIGRATION_WORKBENCH.MD_MIGR_WEAKDEP

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_OTHER_OBJECTS -> MIGRATION_WORKBENCH.MD_OTHER_OBJECTS_TRG

General Info

Caption	MD_OTHER_OBJECTS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_OTHER_OBJECTS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_PACKAGES -> MIGRATION_WORKBENCH.MD_PACKAGES_TRG

General Info

Caption	MD_PACKAGES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_PACKAGES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_PRIVILEGES -> MIGRATION_WORKBENCH.MD_PRIVILEGES_TRG

General Info

Caption	MD_PRIVILEGES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_PRIVILEGES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_PROJECTS -> MIGRATION_WORKBENCH.MD_PROJECTS_TRG

General Info

Caption	MD_PROJECTS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_PROJECTS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_SCHEMAS -> MIGRATION_WORKBENCH.MD_SCHEMAS_TRG

General Info

Caption	MD_SCHEMAS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_SCHEMAS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_SEQUENCES -> MIGRATION_WORKBENCH.MD_SEQUENCES_TRG

General Info

Caption	MD_SEQUENCES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_SEQUENCES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_STORED_PROGRAMS -> MIGRATION_WORKBENCH.MD_STORED_PROGRAMS_TRG

General Info

Caption	MD_STORED_PROGRAMS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_STORED_PROGRAMS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_SYNONYMS -> MIGRATION_WORKBENCH.MD_SYNONYMS_TRG

General Info

Caption	MD_SYNONYMS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_SYNONYMS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_TABLES -> MIGRATION_WORKBENCH.DEL_MD_TRIGGERS_T_TRG

General Info

Caption	DEL_MD_TRIGGERS_T_TRG
Entity Name	MIGRATION_WORKBENCH.MD_TABLES

Body

BEGIN
   DELETE FROM MD_TRIGGERS WHERE MD_TRIGGERS.TABLE_OR_VIEW_ID_FK = :OLD.ID AND MD_TRIGGERS.TRIGGER_ON_FLAG = 'T';
 END;

Trigger Properties

Trigger Fire	AFTER
Trigger Events	Delete
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_TABLES -> MIGRATION_WORKBENCH.MD_TABLES_TRG

General Info

Caption	MD_TABLES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_TABLES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_TABLESPACES -> MIGRATION_WORKBENCH.MD_TABLESPACES_TRG

General Info

Caption	MD_TABLESPACES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_TABLESPACES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_TRIGGERS -> MIGRATION_WORKBENCH.MD_TRIGGERS_TRG

General Info

Caption	MD_TRIGGERS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_TRIGGERS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES -> MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES_TRG

General Info

Caption	MD_USER_DEFINED_DATA_TYPES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_USER_DEFINED_DATA_TYPES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_USER_PRIVILEGES -> MIGRATION_WORKBENCH.MD_USER_PRIVILEGES_TRG

General Info

Caption	MD_USER_PRIVILEGES_TRG
Entity Name	MIGRATION_WORKBENCH.MD_USER_PRIVILEGES

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_USERS -> MIGRATION_WORKBENCH.MD_USERS_TRG

General Info

Caption	MD_USERS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_USERS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_VIEWS -> MIGRATION_WORKBENCH.DEL_MD_TRIGGERS_V_TRG

General Info

Caption	DEL_MD_TRIGGERS_V_TRG
Entity Name	MIGRATION_WORKBENCH.MD_VIEWS

Body

BEGIN
   DELETE FROM MD_TRIGGERS WHERE MD_TRIGGERS.TABLE_OR_VIEW_ID_FK = :OLD.ID AND MD_TRIGGERS.TRIGGER_ON_FLAG = 'V';
 END;

Trigger Properties

Trigger Fire	AFTER
Trigger Events	Delete
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MD_VIEWS -> MIGRATION_WORKBENCH.MD_VIEWS_TRG

General Info

Caption	MD_VIEWS_TRG
Entity Name	MIGRATION_WORKBENCH.MD_VIEWS

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP -> MIGRATION_WORKBENCH.MIGR_DATATYPE_MAP_TRG

General Info

Caption	MIGR_DATATYPE_MAP_TRG
Entity Name	MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_MAP

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE -> MIGRATION_WORKBENCH.MIGR_DATATYPE_RULE_TRG

General Info

Caption	MIGR_DATATYPE_RULE_TRG
Entity Name	MIGRATION_WORKBENCH.MIGR_DATATYPE_TRANSFORM_RULE

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER -> MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER_TRG

General Info

Caption	MIGR_GENERATION_ORDER_TRG
Entity Name	MIGRATION_WORKBENCH.MIGR_GENERATION_ORDER

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES

MIGRATION_WORKBENCH.MIGRLOG -> MIGRATION_WORKBENCH.MIGRLOG_TRG

General Info

Caption	MIGRLOG_TRG
Entity Name	MIGRATION_WORKBENCH.MIGRLOG

Body

BEGIN
   if inserting and :new.id is null then
         :new.id := MD_META.get_next_id;
     end if;
 END;

Trigger Properties

Trigger Fire	BEFORE
Trigger Events	Insert, Update
Correlation Name - OLD	OLD
Correlation Name - NEW	NEW
For Each Row	YES