SQL Loader: Sort the datafile [message #304692] |
Thu, 06 March 2008 03:36 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
@rpita
Messages: 7 Registered: February 2008 Location: Mumbai,India
|
Junior Member |
|
|
Is it somehow possible to sort the datafile coming in via SQL Loader. For example, we have fixed length data coming in and we know that columns 2 thru 10 is numeric data. Can we get the datafile sorted on these positions somehow before the load.
|
|
|
|
Re: SQL Loader: Sort the datafile [message #304700 is a reply to message #304692] |
Thu, 06 March 2008 04:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Even though you'd load a sorted file (doesn't matter how you'd do that (sorting, I mean)), it does NOT mean that "SELECT * FROM this_table" will return result which will be ordered by anything. If you want to fetch records ordered by something, you MUST use the ORDER BY clause in the SELECT statement.
|
|
|