Archive: December 2005

Oracle 10G New Purge feature

Posted by mustapha under Oracle
[7] Comments | No Trackbacks
Purge is useful in 10g when you want to "really truly drop a table". In 10g, tables can be restored after being dropped.

When you drop a table in 10g like this:
drop table table_name;

Oracle renames it (moves it to the recyclebin) and the table is not (truly) dropped.
You can get it back:

» Read More

 

Getting data from MySQL in XML

Posted by mustapha under MySQL
[3] Comments | No Trackbacks
This tip is very helpful specially in data transmission between systems.

Suppose we have a database named "mydb".
>>mysql -uyour_login_name -pyour_password
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.0.25-nt-max

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

Change your_login_name and your_password with your mysql's login name and password.

» Read More