Return
-
Title
The Create Insert option is no longer in the sub-menu for the data grid -
Description
I was on Toad for Oracle 9.7.2.5 and I was able to right-click the data grid and choose the option "Create INSERT for selected rows" to create insert statements of rows. But I upgraded to Toad for Oracle 10.6.1 and that options is now missing from the sub-menu.
-
Cause
There has been menu changes since Toad for Oracle 10.0 and the Insert Statement option is included in the Export Dataset option found on the sub-menu.
-
Resolution
To perform the “Create Insert” for rows in Toad for Oracle 10.x, do the following:
1. Right-click the data grid and select Export Dataset.
2. Under Export Format drop-down, select Insert Statements.
3. Then in the options below, select a file name output, and any other check box options desired.
4. Click OK to generate the SQL file.