Running a Saved Script in TOAD
Clearance for Toad login credentials must be initiated by a manager via a Footprints ticket to Alamo Colleges Information Technology Services (ITS); Applications.
Ensure the Footprints ticket includes the Database(s) that should be accessible to the user.
A Toad Application Install must also be requested from ITS, as software needs to be added to the user's computer.
Once the login credentials are provided to you, proceed with the following to log into Toad for Oracle.
Select File from the menu toolbar then Open File.
Double-click or Select the script you would like to run and click Open.
The script will then be opened in the Editor.
You can now edit the script if necessary, or Execute the Statement by clicking on the icon below (or pressing F9).
The data pulled from your query statement will display below in the Data Grid.
Sorting through your dataset is made easier with the following icons.
- Show/Hide Columns
- Export Dataset (see Exporting Dataset in the next section)
- First Record
- Previous Record
- Next Record
- Last Record
- Cancel Data Fetch
- First Record
- Previous Record
- Next Record
- Last Record
- Refresh Dataset
- Bookmark
- Go to Bookmark
- Single Record View
Every column has a filter feature. Clicking on the column allows you to access it.
Click Custom to find specific data, as shown below.
Refer to the image below.
Right-clicking on the dataset or clicking on the icon indicated will allow you to export the dataset.
There are various formats for the export, the most popular is the Excel File Format.
0 Comments
Add your comment