MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals.

A new video demo add in SQLPLex video section  show the process to build a partition table in the MySQL database server 5.1 using the new DreamCoder for MySQL ver 5.0.

Before a client can start to access and consume services on a network, they must first be Authenticated to the network and then Authorized to use the services they are entitled too. 

MySQL a liberado una intersante guia para el escalamiento y replicación de una base de datos MySQL en idioma español.

This is a very useful script when you need drop all the objects in a schema.

Execution process in the DreamCoder for Oracle.

1. Open the script in the SQL Editor.
2. Open the SQL output
3. Execute the script with F9.

 

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.

In normal SQL you can do an Order by to order by a certain column. Write desc after this to do this descending instead of ascending. I guess you all know that.

But what if I want to order by the last character of a certain column. You can use this order by clause:

Oracle 9i and up provide you with a new keyword: DEFAULT. This means you can get to the default values of a column when doing an insert or update.

I have tried some things with this on my 10G XE database and I have come up with the following script to test it all (a bit).

When I was presented with the possibilities of Rulegen it made me wonder: How can these rules be tested. Rulegen is a tool to create rules in the database by just typing in some SQL queries. Rulegen will then use this input to generate a couple of triggers and a package to enforce these rules.

In Oracle PL/SQL you have the possibility to call another program with parameters either by position or by name. Both have their pros and cons I think.