I have data from the query like below which is returning around 2 million records.
select col1, col2 from table1
Now how to export data to an excel?
Also if the table contains more than 30 million records, can we export the data to a flat file? as I think excel cannot hold more than 65000 records?