Toad – SQLNET Editor and TNS Names Editor Disabled

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

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

Oracle – Toad – Add an external tool to the tool bar

Click on the “configure” button as below Toad Tool Option dialog box will open then click on the “Auto add…” button Below screen will open after that you can selecte the listed program ( as we selected Notepad) then click “OK” Now you can check the your selected program add in the tool bar   Similarly, you can add your desired program here.

» Read more