Discussions
Categories
- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 75 Insurance
- 537.7K On-Premises Infrastructure
- 138.7K Analytics Software
- 38.6K Application Development Software
- 6.1K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.3K Infrastructure Software
- 105.4K Integration
- 41.6K Security Software
Able to create external table to query csv files as a table...

I think it would be nice to be able to create a external that points to a .csv that I can then query like a regular table.
Each csv columns will represent a table column.
Comments
-
This is what External Tables were designed to do.
I believe that you can use SQL*Developer to create the necessary parameters.
Now, if the CSV was a CLOB (or BLOB) in a table (eg APEX "File Browse..." Item), then you'll want to up-vote this:
Other than that, you will need to explain what you want with more details.
MK
-
This is what External Tables were designed to do.
I believe that you can use SQL*Developer to create the necessary parameters.
Now, if the CSV was a CLOB (or BLOB) in a table (eg APEX "File Browse..." Item), then you'll want to up-vote this:
Other than that, you will need to explain what you want with more details.
MK
Thanks Mike. I want to be able to read the data in a .CSV without loading the data. I can see how your idea could come in handy, but it's different from what I'm looking for.
-
I'm going to vote Up. The reason is because this has already been implemented...many many versions ago. Here is the Oracle documentation on the subject:
Either that, or I missed the point entirely.
Now querying a .xlsx file directly from an external table...now there's an idea!
Cheers,
Brian -
Thanks Mike. I want to be able to read the data in a .CSV without loading the data. I can see how your idea could come in handy, but it's different from what I'm looking for.
External Tables do not load the data. They do use the SQL*Loader engine to read from the .csv file, but data is not loaded to the database.
-
External Tables do not load the data. They do use the SQL*Loader engine to read from the .csv file, but data is not loaded to the database.
I know that @BPeaslandDBA.
-
I'm going to vote Up. The reason is because this has already been implemented...many many versions ago. Here is the Oracle documentation on the subject:
Either that, or I missed the point entirely.
Now querying a .xlsx file directly from an external table...now there's an idea!
Cheers,
BrianBPeaslandDBA wrote:Now querying a .xlsx file directly from an external table...now there's an idea!Cheers,
BrianHmmm... can you pass a BFILE to the XMLType() that is part of an XMLTable() ???
MK
-
I'm going to vote Up. The reason is because this has already been implemented...many many versions ago. Here is the Oracle documentation on the subject:
Either that, or I missed the point entirely.
Now querying a .xlsx file directly from an external table...now there's an idea!
Cheers,
BrianI'll like to see that @BPeaslandDBA. Though .xlsx can be rather problematic to query. It's not as straightforward.
-
.xlsx is a proprietary format. Not only could it change in the next release of Excel, but it can contain objects other than just text.
How would it copy with embedded objects, for example?
-
I know that @BPeaslandDBA.
BCG14 wrote:I know that BPeaslandDBA.
Then why suggest something that you know already exists?
-
BCG14 wrote:I know that BPeaslandDBA.
Then why suggest something that you know already exists?
My reply was that I know that external table is meant to ready data.