![]() |
|
In order to identify those tuples that violate an integrity constraint whose activation failed, one can use the clause exceptions into EXCEPTIONS with the alter table statement. EXCEPTIONS is a table that stores information about violating tuples.3 Each tuple in this table is identi~ed by the attribute ROWID. Every tuple in a database has a pseudo-column ROWID that is used to identify tuples. Besides the rowid, the name of the table, the table owner as well as the name of the violated constraint are stored. Business - All business/finance/loan/mortgage related link can be found heremore 1 2 3 4 5 Computers - All computer hardware/software/peripheral related link can be found here Internet - All webhosting/webdesign/internet marketing related link can be found here Software - All software related link can be found here Web Design - All web design/development related link can be found here Web Hosting - All web hosting related link can be found here Web Promotion - All search engine optimization/internet marketing related link can be found here Web Resources - All other web related link can be found here Recreation - All travel/hotel/cruise related link can be found here Casino - All online gambling/poker/blackjack/roulette related link can be found here Health - All online pharmacy/hospital/health related link can be found here Shopping - All online shopping/gift related link can be found here Miscellaneous - All other links can be found here
In order to enable an integrity constraint, the clause enable is used instead of disable. A constraint can only be enabled successfully if no tuple in the table violates the constraint. Otherwise an error message is displayed. Note that for enabling/disabling an integrity constraint it is important that you have named the constraints. |
|
| © Copyright 2006 CodeInvent.com All Rights Reserved. |