| |
| | Mike Ault's Blog: April 2005 |
 | | As to the EXCEPTIONS clause, my understanding of an exception is that you get a ordinal value, a "zero" case, then, when duplicates (in the case of a primary key) are found, they are exceptions however, as has been shown to me, Oracle treats all occurrences, ordinal or not, as exceptions. |
 | | Also seems to indicate that every line in the exceptions table is an exception, when there are clear cases where the line will be a valid row, not an exception. |
 | | This generated the rows and then using a primary key constraint with the exceptions clause I would then be able to delete the duplicates leaving my good rows. |
| mikerault.blogspot.com /2005_04_01_mikerault_archive.html (5393 words) |
|