Once trigger is created its source code is stored in which types of data dictionary view?

Options
- Views_trigger
- User _ trigger
- Triggers
- System_trigger

CORRECT ANSWER : User _ trigger

Discussion Board
USER_TRIGGER

USER_TRIGGERS describes the triggers owned by the current user. Its columns (except for OWNER) are the same as those in ALL_TRIGGERS.

Prajakta Pandit 02-23-2017 11:10 PM

Correct annswer "User _ triggers "

Correct annswer "User _ triggers "
SQL> desc user_triggers
Name Null? Type
------------------------------- -------- --------------------

1 TRIGGER_NAME VARCHAR2(30)
2 TRIGGER_TYPE VARCHAR2(16)
3 TRIGGERING_EVENT VARCHAR2(227)
4 TABLE_OWNER VARCHAR2(30)
5 BASE_OBJECT_TYPE VARCHAR2(16)
6 TABLE_NAME VARCHAR2(30)
7 COLUMN_NAME VARCHAR2(4000)
8 REFERENCING_NAMES VARCHAR2(128)
9 WHEN_CLAUSE VARCHAR2(4000)
10 STATUS VARCHAR2(8)
11 DESCRIPTION VARCHAR2(4000)
12 ACTION_TYPE VARCHAR2(11)
13 TRIGGER_BODY LONG
14 CROSSEDITION VARCHAR2(7)
15 BEFORE_STATEMENT VARCHAR2(3)
16 BEFORE_ROW VARCHAR2(3)
17 AFTER_ROW VARCHAR2(3)
18 AFTER_STATEMENT VARCHAR2(3)
19 INSTEAD_OF_ROW VARCHAR2(3)
20 FIRE_ONCE VARCHAR2(3)
21 APPLY_SERVER_ONLY VARCHAR2(3)


harish 03-13-2015 09:22 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲