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.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center