Return
-
Title
ER - Describe Window and Schema Browser, right click "Generate SQL statement -
Description
In Toad 9.7 and older, a user could type "hr.employees" in Toad Editor, open the Describe Window with F4, ctrl+left-click and select columns in the Columns tab, right mouse click and "generate select statement." Then they could paste the select statement into the editor and it would have just contain the columns they selected. Similar steps were available for Generate insert, and Generate update. The same steps also work in the Schema Browser's right hand side.
In Toad 10 and newer, you cannot select Generate Statement from the right mouse click in Describe Window's column tab. You can go into the Object Palette, drop down to the schema you want, find the table, right mouse click and go to Action Console. From the Action Console you can select "generate statement" but the statement will contain all columns in the table, so you have to go and delete the ones you don't want. This is a lot more steps and this is more difficult if you're working with tables with a lot of columns. (In the Schema Browser, "generate statement" has also been removed from the right mouse click on the RHS, but is still available on the LHS. But again, you can't ctrl+left-click the columns you want into a Generate Statement) -
Resolution
STATUS:
An enhancement request has been submitted to the development team for consideration in a future release of Toad for Oracle.
-
Defect ID
ST75882