What does the base_object_type column shows in the user.triggers data dictionary view?
- 1 Answers
- 1135 Views
- I also Faced
- E-Mail Answers
Answer Posted / Shailendra Kumar Rajpoot
The BASE_OBJECT_TYPE column in the USER_TRIGGERS data dictionary view indicates the type of object that the trigger is associated with. It can have one of the following values:n
1. TABLE - Trigger on a table.
2. VIEW - Trigger on a view.
3. PROCEDURE - Trigger on a procedure.
4. PACKAGE - Trigger on a package.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is collation? : Sql dba
Is inner join faster than left join?
what is bcp? When does it used? : Sql dba
what is dbms? : Sql dba
Does group by remove duplicates?
how to start mysql server? : Sql dba
Is primary key always clustered index?
how to use regular expression in pattern match conditions? : Sql dba
how to escape special characters in sql statements? : Sql dba
Can we use distinct and group by together?
What is the current version of postgresql?
Can delete statement be rollbacked?
Do we need to rebuild index after truncate?
What is your daily office routine?
what are the advantages of sql ? : Sql dba
