Answer Posted / manoranan sethy
Constraints are restrict the invalid data before invoke into the database whereas trigger restrict the invalid transaction.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What sql does db2 use?
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
can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba
How many sql databases can you have on one server?
What is user defined functions?
Can we use update in sql function?
How to write a query to show the details of a student from students table whose
Is trigger a stored procedure?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is not null in sql?
what are set operators in sql? : Sql dba
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is error ora-01000: maximum open cursors exceeded
What is sqlerrm?
What is crud stand for?