Type a table name into an editor window, press F4 to describe it. Select the “Script” tab and the options icon. Select the “Tables” tab and check the Insert Statements checkbox and click ok.
Previous behaviour was that insert statements would be generated for all of the data in the table; using 22.214.171.124 this no longer happens. I don’t know when this stopped working - it’s not something I use every day but it is a useful function.
While you’re fixing that, would it be possible to enhance it slightly so that if you have applied a filter to the table, only insert statements are generated for the rows currently being returned? I’m currently working on a small project where I set up some data in bespoke tables using a screen in Oracle eBiz. To move the data to another database, I just want to describe the table, filter it to the rows I’ve just created and then generate the insert statements for them. Currently (or I should say previously when it worked!) it will generate insert statements for the entire table which could be thousands of rows and then I have to find the few I need.