Quote:
Originally Posted by
junior-helper
I don't quite understand why you are suggesting SQL*loader for this task. There's nothing to load/insert
Well, that's why I suggested external tables first
But from a DB standpoint, I see the data as needed in the database, hence the load. Agreed, he didn't explicitly ask how to load it, but it's implied on how he wants to use the data.
As a learning experience, I tried playing with paste a bit based on those earlier posts, and couldn't get it working in Oracle, hence my comments on "still not sure about this"
Just going by what I know is a basic, and robust solution:
1) load data into a table.
2) use data in table in query.
since in Oracle, it's very "odd" to use data in a query "Directly" from a file (other than perhaps an external table).