Feature Request: Importing data using script

[Bhupen]

Text Import is probably my most used tool (besides using sql script), which has saved me a lot of hrs.
I wish there was a way to insert data using a script, so that I can insert and do whatever data manipulation I need to do in one go.
Don't know how this could be accomplished thought? May be using some custom plsql dev syntax (similar to &variable), that can take the file (csv, excel) as input from the UI and be used with an insert script.

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[William Robertson]

Have you tried pasting from Excel into a results grid?

 

[Bhupen]

Oh, I did not know that could be done. That would help a lot. Thx!

My workflow a lot of the times involves the following...
1. Import data from text/excel source in a temp table.
2. Some data cleansing/manipulation.
3. Insert data into its final destination.

I can do steps 2 and 3 in one block of code however, step 1 has to be done prior to that separately.
If there was to do step 1 in the same block of plsql code (providing a local data file as input), that would be the best case scenario.