Database IT Blogs

A short description about your blog
Peter Boekelaar
Why 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.

Peter Boekelaar  The use of XML

XML is more and more the way to interact between databases. There are a lot of companies where XML has become the standard of exchanging data, even between two schemas on the same database. I personally agree on using XML between databases, as long as it is done because the DB's are on different locations, use a different OS, or because it is data exchange between an Oracle and MySQL or other DB.

Tagged in: XML , PL/SQL , oracle database , development

Advertisement

Featured Links:
DreamCoder for MySQL Enterprise at USD 69.95
Powerful and easy MySQL IDE tool for Developers & DBAs.
DreamCoder for Oracle DBA at USD 99.95
The top IDE for Developers & DBAs for Oracle Databases.
DreamCoder for PostgreSQL Enterprise at USD 69.95
Powerful IDE for PostgreSQL Databases.

Tags