I do a DESC via F4 on a table with multiple columns.
I take notice of the columns' order.
I double-click on a table within the editor.
I right click and bring up the action Console...
I select Generate Insert Statements.
I open another Editor SQL tab.
I paste the generate insert statements into new editor tab.
I notice the columns order are alphabetized and not in column ID order.
In the toad.ini file, the TMDIDescribeForm_options is corrupted.
WORKAROUND 1:
1.Double click on table to do describe via F4.
2. On the table’s ID column, click on its heading twice to sort the column in ascending order.
3. Do a Select All (Control-A) to select of the table columns in Describe window.
4. On the Describe window’s icon ribbon, click on the Generate Statement icon (ninth icon from the right)
5. On the context menu, select Generate Insert Statement.
6. Open an Editor and paste the clipboard contents.
7. All the tables columns will be sorted proper order via the Generate Insert Statement.
8. All subsequent Generate Insert Statement actions will follow the current ascending ID sort pattern.
WORKAROUND 2
1. With Toad for Oracle closed, rename the Toad.ini file in the Application Data Directory.
The exact location of the Application Data Directory can be determined from the Toad for Oracle Support Bundle (Help | Support Bundle) .
On the seventh line starting with User Profile Directory For example: C:\Documents and Settings\<user>\Application Data\Quest Software\Toad for Oracle\10.6\
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center