Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What is the starting oracle error number?
What do you mean by query optimization?
how many columns can be used for creating index? : Sql dba
What is dml and ddl?
Which is faster truncate or drop?
What is the usage of when clause in trigger?
How would you reference column values before and after you have inserted and deleted triggers?
what tools available for managing mysql server? : Sql dba
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What are the different types of sql commands?
what is the difference between where clause and having clause? : Sql dba
What is trigger types of trigger?
What is the syntax to add a record to a table?
What is package in pl sql?
Write the command to remove all players named sachin from the players table.
