Tag: Toad

Toad – SQLNET Editor and TNS Names Editor Disabled

Oracle, Oracle-Tips and Tricks, Oracle-Utilities, Varinder Sandhu

While trying to connect to a Database using Toad with TNS, Even the TNS entry is created in tnsnames.ora file under Oracle Home\NETWORK\ADMIN Issue 1: SQLNET Editor and TNS Names Editor Disabled as shown in below snapshot  Issue 2: Not able to find the TNS Name in the dropdown as shown in below snapshot Cause: TNS entry missing in the environmental variables Resolution:  Go to environmental variables and create a new variable Name as “TNS_ADMIN” and set the value as  Oracle Home\NETWORK\ADMIN

» Read more
, , , ,

Oracle – Auto Generate Insert Statement with Toad

Oracle, Oracle-Tips and Tricks, Varinder Sandhu

This is very quick way to generate the Insert Statement for all of the data in your table. Let us take an example; we have a table as shown below… Right click on the Result Grid and go to Option à Export Dataset Select the Export Format as “Insert Statement” Select the Output file location and name You can also change the Schema (if required) Required Out file is ready with Insert statement as If you have any comment/suggestion please

» Read more
, ,