Working with CSV files in SQL Developer
Vinzzz33
-
jee pee Posted messages 9435 Registration date Status Moderator Last intervention -
jee pee Posted messages 9435 Registration date Status Moderator Last intervention -
Hello everyone,
I receive flat files in CSV format from a production database (raw tables without modifications).
The volumes are quite large... And I do not have tools to validate this data.
So my question is the following: is it possible to use SQL Developer on CSV files only (no connection to Oracle databases)?
Thank you in advance.
Vincent
Configuration: Windows / Internet Explorer 11.0
I receive flat files in CSV format from a production database (raw tables without modifications).
The volumes are quite large... And I do not have tools to validate this data.
So my question is the following: is it possible to use SQL Developer on CSV files only (no connection to Oracle databases)?
Thank you in advance.
Vincent
Configuration: Windows / Internet Explorer 11.0
2 answers
Hello,
It doesn't seem to me that you can directly use a .csv in sql*developer.
Why not load it into an Oracle staging table? That remains the simplest solution.
Or if you have Office, process the csv in Excel. Or convert it to an Access table, which can then be used in sql*developer.
Best regards
--
a foreigner is a friend you haven't met yet.
It doesn't seem to me that you can directly use a .csv in sql*developer.
Why not load it into an Oracle staging table? That remains the simplest solution.
Or if you have Office, process the csv in Excel. Or convert it to an Access table, which can then be used in sql*developer.
Best regards
--
a foreigner is a friend you haven't met yet.
Can we create Oracle tables locally with SQL Developer?
I was advised to use MySQL, which would allow me to create/declare my tables locally and import my various tables in CSV format into it. Is that possible? If so, which version/components of MySQL should I use?
Thank you
Vincent
I was advised to use MySQL, which would allow me to create/declare my tables locally and import my various tables in CSV format into it. Is that possible? If so, which version/components of MySQL should I use?
Thank you
Vincent