Extracting information from a toad spec file datafile to MySQL

Asked By Pam Lendrum 10 points N/A Posted on - 03/30/2013

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.

 

• Status: Open
• Question Views: 773
• Answer Count: 1
• Vote Up 1 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Baldwin Coll 0 points N/A #162790

Extracting information from a toad spec file datafile to MySQL

 

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%, 

 

About Baldwin Coll

Questions
0

Answers
22

Best Answers
10

• Vote Up 0 Vote Down

• Posted on - 04/30/2013
• Question Category: Oracle Database