MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals.
Database IT Blogs
Articles, tips and tricks for databases
Tags >> developers
Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.6.0.Tagged in: mysql database , developers
Mentat Technologies announces the new minor update of DreamCoder for MySQL version 4.9.4.0.
Tagged in: mysql database , developers
Mentat Technologies announces the new minor update of DreamCoder for Oracle version 4.2.4.0.
Currently I am working on an application that runs one or more listener threads using scheduled tasks (DBMS_SCHEDULER). When I want to compile a piece of code that is effectively locked by one of these processes my IDE locks up, until I shut down the tasks. The first couple of times I was wondering what was happening and why my code wouldn’t compile. In a later stage I found out that the scheduled tasks was the problem.
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.
Bloggers
| Patrick Barel (26) |
|
| SQLDeveloper (30) |
|
| Peter Tesone (8) |
 |
| MySQL Channel (24) |
|
| Peter Boekelaar (2) |
|
Advertisement
Tags
Archive
