Wojtek
Member²
Lately I had ocassion to use Text Importer tool build-in PLSQL DEVELOPER.
I had excel table with over 140 columns and over 20k rows.
I started to look after some tool. SQL Loader - external tables, TOAD, SQL Nav,... but I couldn't find any occurate.
Hmmm..Polish proverb tells that: "the most darknes are near street lamp".
There is a great tool supported with Plsql Developer!
When I started to use it, it occurs, that
... it would be beter than great if there would be:
1. option to CREATE table with structure the same as defined columns (or some predefined columns i.e. c1, c2...with default string type). Now you must to have ready to use table, so u must create a table first.
2. If u have over a 100 columns entering of the column names is very arduous. So it would be nice that table fields would have the same name as a columns name, or if column name is too long it would be smart cutted.
3. If u start to use Text Importer, u can't use PLSQL Dev, because its in bacground, and u have to close Text Importer first (why?) to go back to PLSQL Dev.
I have no other comments. Hope that this tool will be developing, becouse for now, there's no competitor apps, which have such a functionality.
Regards
I had excel table with over 140 columns and over 20k rows.
I started to look after some tool. SQL Loader - external tables, TOAD, SQL Nav,... but I couldn't find any occurate.
Hmmm..Polish proverb tells that: "the most darknes are near street lamp".
There is a great tool supported with Plsql Developer!
When I started to use it, it occurs, that
... it would be beter than great if there would be:
1. option to CREATE table with structure the same as defined columns (or some predefined columns i.e. c1, c2...with default string type). Now you must to have ready to use table, so u must create a table first.
2. If u have over a 100 columns entering of the column names is very arduous. So it would be nice that table fields would have the same name as a columns name, or if column name is too long it would be smart cutted.
3. If u start to use Text Importer, u can't use PLSQL Dev, because its in bacground, and u have to close Text Importer first (why?) to go back to PLSQL Dev.
I have no other comments. Hope that this tool will be developing, becouse for now, there's no competitor apps, which have such a functionality.
Regards
