News Updates
|
By Peter Boekelaar
17 Apr 2009
Section
Oracle database
|
Cascade delete scriptWhy this script? Most of the FK's defined in an Oracle DB, are not created using the on delete cascade option, since that is (most of the times) not wanted at all. But sometimes records must be deleted while it is not allowed to do so, because there are child records (or a complete tree of child records) present. For cases like that I use a script that searches the DB for child recs, using the SYS views. |
|
By Patrick Barel
16 Apr 2009
Section
Oracle database
|
Simple comparison SQL
I am comparing tables in two different schemas. Since I am doing the same thing over and over again I created a small script which might be useful to you too.
|



