Recent Developments Of Empysema

Package

To see the body of our package we have to check first that we installed version of Oracle.

If it is equal to or later versions to exploit the package just nine native dbms_metadata. With this query we get what we want:

SQL> select dbms_metadata.get_ddl ('PACKAGE', '') from dual;

If we need to versions prior to nine use tables all_source:

SQL> desc all_source;

Name Null?

Type --------------------------------- -------- ---- ---------------------------------------------

OWNER VARCHAR2 (30)

NAME VARCHAR2 (30)

TYPE VARCHAR2 (12)

LINE NUMBER

TEXT VARCHAR2 (4000)

and make this query if you want the definition of the package:

SELECT text FROM

all_source

WHERE owner = 'OWNER_PACKAGE '

AND name = 'NOME_PACKAGE ' AND type =

'PACKAGE' ORDER BY

type, line;

and this also if you want the body:

SELECT text FROM

all_source

WHERE owner = 'OWNER_PACKAGE' AND name =

'NOME_PACKAGE'

AND type = 'PACKAGE BODY' ORDER BY

type, line;

You can look at the description of the package simply laciando function desc:

SQL> desc OWNER_PACKAGE.NOME_PACKAGE;

What Is Nelson's Syndrome

Oracle Oracle Trigger

The main triggers are tables covering the following :

user_sequences

user_triggers

all_triggers

here are their descriptions:

SQL> desc user_triggers

Name Null?

Type --------------------------- -------- ---------- ---------------------------------------

TRIGGER_NAME VARCHAR2(30)

TRIGGER_TYPE VARCHAR2(16)

TRIGGERING_EVENT VARCHAR2(216)

TABLE_OWNER VARCHAR2(30)

BASE_OBJECT_TYPE VARCHAR2(16)

TABLE_NAME VARCHAR2(30)

COLUMN_NAME VARCHAR2(4000)

REFERENCING_NAMES VARCHAR2(128)

WHEN_CLAUSE VARCHAR2(4000)

STATUS VARCHAR2(8)

DESCRIPTION VARCHAR2(4000)

ACTION_TYPE VARCHAR2(11)

TRIGGER_BODY LONG

SQL> desc user_sequences

Name Null? Type

--------------------------- -------- -------------------------------------------------

SEQUENCE_NAME NOT NULL VARCHAR2(30)

MIN_VALUE NUMBER

MAX_VALUE NUMBER

INCREMENT_BY NOT NULL NUMBER

CYCLE_FLAG VARCHAR2(1)

ORDER_FLAG VARCHAR2(1)

CACHE_SIZE NOT NULL NUMBER

LAST_NUMBER NOT NULL NUMBER

SQL> desc all_triggers

Name Null? Type

--------------------------- -------- -------------------------------------------------

OWNER VARCHAR2(30)

TRIGGER_NAME VARCHAR2(30)

TRIGGER_TYPE VARCHAR2(16)

TRIGGERING_EVENT VARCHAR2(216)

TABLE_OWNER VARCHAR2 (30)

BASE_OBJECT_TYPE VARCHAR2 (16)

TABLE_NAME VARCHAR2 (30)

COLUMN_NAME VARCHAR2 (4000)

REFERENCING_NAMES VARCHAR2 (128)

WHEN_CLAUSE VARCHAR2 (4000 )

STATUS VARCHAR2 (8)

DESCRIPTION VARCHAR2 (4000)

ACTION_TYPE VARCHAR2 (11)

TRIGGER_BODY LONG

select This gives us an overview of the trigger of our interest:

SQL> SELECT trigger_name, trigger_body from all_triggers WHERE trigger_name = '';

instead and this gives us the status:

SQL> select status from all_triggers WHERE trigger_name = 'CUSTOM_CDR_DATA_RTRIG';