Interested to Buy Any Domain ? << Click Here >> for more details...
How to recompile a already made trigger?
- 2 Answers
- 11783 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / chandrakant agrawal
To recompile Trigger:
ALTER TRIGGER <trigger_name> COMPILE;
The trigger can be enabled and disabled manually by using:
Alter Table <table_name> disable(enable) all trigger;
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / mk
Usually the trigger code is in a file e.g. trigger_name.sql
To create/replace the trigger object, at the SQL Plus prompt
type
@<folder>/trigger_name.sql
| Is This Answer Correct ? | 0 Yes | 2 No |
What are the main features of cursor?
where are cookies actually stored on the hard disk? : Sql dba
Why do we use sql constraints? Which constraints we can use while creating database in sql?
What are the differences between in and exists clause?
I have a table .in the table 100 recored is there .we have get the single row with out using clause..
What is sql and db2?
How to look at the current sql*plus system settings?
Which nosql database is best?
How do you update sql?
Why do we use view in sql?
What is pivot query?
How to move files from one directory to another in pl sql?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
