The path to the temp directory in Java can be retreived via the sytem property as mentioned below:

System.getProperty("java.io.tmpdir");

Back to Top

All the oracle sequences are stored in a table called "dba_sequences".

The following query selects the min, max ,current value along with the length current value and orders it by the length in desc.

select SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER)

from dba_sequences

where SEQUENCE_OWNER='schema owner'

order by length(LAST_NUMBER)desc;

Back to Top

Yes, you can view triggers using the INFORMATION_SCHEMA.TRIGGERS table. The following sql list all the triggers in a given schema.

select

SEQUENCE_NAME,MIN_VALUE,MAX_value,LAST_NUMBER,length(LAST_NUMBER)

from dba_sequences

where SEQUENCE_OWNER='schema owner'

order by length(LAST_NUMBER) desc

Back to Top

The following sql list the name of all the routines in a given database.

SELECT ROUTINE_NAME

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_TYPE="PROCEDURE" AND ROUTINE_SCHEMA="dbname";

Back to Top

The table types have changed from ISAM to MYISAM from Mysql version 4.x to 5.x.

In order to convert a table from ISAM to MyISAM, simply issue a statement like

ALTER TABLE tblname ENGINE=MYISAM.

Back to Top

Data can be dumped into the database using the following command. mysql -p -h DBSERVER dbname < dbname.sql

Back to Top