title: Exporting large results of a MySQL and Oracle Query
body: <p>I am testing data migration for which I have created 2 SQL scripts , one for Oracle server and 1 for MySQL. My idea is to export their results to a .txt files and then compare it using unix DIFF.
  It works perfectly for small files but for large files the clients for Oracle and MySQL do not support such huge file to be exported.</p>
  
  <p>One way is to break query results and then compare but it is extremity time consuming.In my opinion if I could break the resultset in batches using some program, it could be possibel.</p>
  
  <p>Please suggest me a easy method to do that.
  Thanks
  Ajay</p>