Extracting information from a toad spec file datafile to MySQL

Asked By 10 points N/A Posted on -
qa-featured

Hallo Code Gurus! I need a code to extract information from a toad spec file datafile and be able to convert the same into MySQL database. Could there be any possibility of a code that does the job automatically from the file to a MySQL database? I need this and notes on how to do it to enable me to use the data in my new website made on xampp platform.

 

SHARE
Answered By 0 points N/A #162790

Extracting information from a toad spec file datafile to MySQL

qa-featured

 

1. SELECT count(*) AS Cnt1 FROM tsau_pre_msges WHERE ( (EXTRACT (DAY FROM Jms_timestamp) -EXTRACT (DAY FROM ins_time))*24*60 + (EXTRACT (HOUR FROM Jms_timestamp)-EXTRACT (HOUR FROM ins_time))*60 + EXTRACT (MINUTE FROM Jms_timestamp)-EXTRACT (MINUTE FROM ins_time) ) BETWEEN 1 AND 5 
 
It will count messages from total in the next query it vl give percentage from the count value of total messages
 
 2. Select tot*100 total from (select Cnt1/t tot from (select max (Cnt1) it from tsau_pre_msges ), tsau_pre_msges ) so that i get output as 
 
Example:40 20%, 

 

Login/Register to Answer

Related Questions