title: How view data that comes from a .GZ File Format on ORACLE SQL?
body: <h2>EXPLANATION OF MY CONDITION AND PROBLEM I AM FIGURING</h2>
  
  <p>I find this a bit too complicated, maybe because I am new to this event and the world of LINUX.</p>
  
  <ol>
  <li>So I am here on my PC (WINDOWS 7) then I need to make a sql based reporting site but the data I need is not in oracle yet.</li>
  <li>I need to view the data in oracle sql that comes from many files from another controller -> another PC (UNIX).</li>
  <li>The format of the file is originally .gz but physically its FILE FORMAT is like this machinedump.log.gz05052012 (Its still .gz -> inside is a .log but still a .txt content)</li>
  </ol>
  
  <p>Note: that controller/personal computer that I am connecting has a username, password and port number.</p>
  
  <p>Inside each .log.gz data it has a data like:</p>
  
  <pre><code>20120806_161944: 08.06 16:17:29.574 t_cm_03 C3011099140000 at_sts       =    0 
  20120806_161944: 08.06 16:17:29.574 t_cm_03 C3011099140000 at_sts       =    1
  20120806_161944: 08.06 16:17:29.574 t_cm_03 C3011099140000 at_sts       =    2
  20120806_161944: 08.06 16:17:29.574 t_cm_03 C3011099140000 at_sts       =    3
  20120806_161944: 08.06 16:17:29.574 t_cm_03 C3011099140000 at_sts       =    4 
  20120806_161944: 08.06 16:17:29.574 t_cm_03 C3011099140000 at_sts       =    5
  20120806_161944: 08.06 16:17:29.574 t_cm_03 C3011099140000 at_sts       =    6
  20120806_161944: 08.06 16:17:29.574 t_cm_03 C3011099140000 at_sts       =    7
  </code></pre>
  
  <p>But there is a more bigger problem too that I see:
  The MACHINEDUMP.LOG.GZ files are many like:</p>
  
  <pre><code>machinedump.log.gz05052012
  machinedump.log.gz05062012
  machinedump.log.gz05072012
  machinedump.log.gz05082012
  etc.
  </code></pre>
  
  <h2>So here is QUESTION and HELP NEED to my problem:</h2>
  
  <ol>
  <li><p>I wanna ask you guys what is the best way to store these file contents into a single table?
  from those .LOG.GZ files to a single Table?</p></li>
  <li><p>Regarding on the 1st question, is it too possible to make the data fetching based on the "date" automated?
  Meaning if there is a file that match the present date, it would execute and save those data to desired table?</p></li>
  <li><p>Is there a way you guys could show me what to do?</p></li>
  <li><p>In addition guys, is there anything here that I must study deeply?</p></li>
  </ol>
  
  <p>I need to make these data a usefull and readable report on using atleast SQL(oracle or is there any better way) and NETBEANS to do the rest of the job(These I know).</p>
  
  <h2>MODERATORS</h2>
  
  <p>Is it possible to have my previous failed Question DELETED? Thanks...</p>