How do I can quickly open a 8Gb dsv file with 40 million rows with oracle sql developer? I did it with a best laptop with high cpu speed but it took one day, I'm looking for a faster way...
How many rows will the following SQL return :
Select * from emp Where rownum = 10;
Select * from emp Where rownum < 10;