Introduction
Connect
Create Amazon Redshift Connections
Create ODBC Connections
Create Oracle Connections
Create Snowflake Connections
Create SQL Server Connections
Create SharePoint Connections
Understand Toad Connections
Troubleshoot SQL Server Connections
Understand
Determine the Best Method to Locate Objects
Object Explorer
Filter Databases and Objects
Understand a Table Using the Database Explorer
Search for Objects
Create an Database Diagram to Use as a Query Template
Browse Data in Related Tables
Query
Tutorial: Build a Query Visually
Create Cross-Connection Queries
Reverse Engineer Queries
Build a Subquery
Edit SQL
Editor Shortcut Keys
View Result Sets
Compare Differences in Data
Export Data with One Click Export
Share Excel Linked Queries
Automate
Add Connection Parameters to Open Toad Data Studio from Toad for Oracle
This topic focuses on information that may be unfamiliar to you. It does not include all step and field descriptions.To add the latest Toad for Oracle connection information when opening Toad Data Studio from Toad for Oracle
-
Open Toad for Oracle.
- Click the arrow beside
, and select Configure.
- Click Auto add and select Toad Data Studio.
- Select Toad Data Studio and click Edit.
-
Enter the following information in the Parameters field:
/TOADUSER=$UID /TOADPASSWORD=$UPW /TOADDATABASE=$SID /TOADFILE="$FIL"
where:
- /TOADUSER=$UID is the current Toad for Oracle user
- /TOADPASSWORD=$UPW is the current Toad for Oracle password
- /TOADDATABASE=$SID is the current Toad for Oracle database ID
- /TOADFILE="$FIL" is the current SQL Editor file open in Toad for Oracle
- Click the arrow beside