which will fire first ? Trigger or Constraint
Answer Posted / shathar khan
trigger will always executes second.
that is trigger is only to execute when something happens to
the table
Even though trigger automatically executes, it's automatic
execution starts when modification of the table occurs
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How can use stored procedures in sql?
Can function return multiple values in sql?
Is sql a microsoft product?
What is snowflake sql?
How do I run a sql script?
What schema means?
what is myisam? : Sql dba
Does truncate free space?
What is the use of stored procedures?
What does <> sql mean?
what is union? : Sql dba
What are the various restrictions imposed on view in terms of dml?
How to select unique records from a table?
First round ------------------- - Procedure - Packages - Views - Virtual tables - Can we use dcl with in function? - Joins and few scenarios - Triggers and its type - Pragma, type and its functionality - How to create db link in oracle - Materialized view - How to find duplicate values from table? - Cursor and its functionality - Write a script to display friday and its date from a entire year. - Exception Handling Second round ------------------------ Gave a scenario like. Need to write a function to perform. When user try to change a password. It must not be last five password and a given password can be combination of characters, symbols, upper and lower case.
How many postgresql users are there, worldwide?