Enhancement Request : Import defaults

[Steve Godrich]

There is a feature where you can import data from a flat file or something. Sometimes, the table you wish to upload the data to has more columns than the file supplied. Can we dynamically add columns and default values to 'fill in the blanks'?

 

[Marco Kalter]

No, this is currently not possible. The extra columns are omitted in the resulting insert statements, so the default values defined at the table level are applied.

 

[vshah07]

please tell me how can i uploaD THE data from excel to database...

 

[ScottMattes]

You could save the data to a file in csv format and then use the PL/SQL Developer Text Importer on the Tools menu.