SQL
How to list all the sequence in schema with size?
Posted February 1st, 2008 by administrator
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
How to do view all the triggers in a schema?
Posted January 31st, 2008 by administrator
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
How do I import a MySQL dumpfile into my database?
Posted January 1st, 2008 by administrator
Data can be dumped into the database using the following command. mysql -p -h DBSERVER dbname < dbname.sql