Chat now with support
Chat with Support

Toad for Oracle 13.1.1 - Getting Started Guide

Welcome to Toad Toad Resources Required Privileges Create and Manage Database Connections Editor Basics Schema Browser Basics Data Grid Basics Work with Data Work with Database Objects Work with Code
Write Statements and Scripts Work with the Query Builder Execute Statements and Scripts Save Statements (SQL Recall) Work with PL/SQL Objects Debug Analyze Code Optimize SQL
Customize your Toad Environment Use Other Quest Software Products with Toad

Copy Statements between Toad and Development Tools

Sql = " select count(*) as cnt"

Sql = Sql & " from all_tables"

Sql = Sql & " where owner = 'DEMO'"

Sql = Sql & " and table_name = 'EMPLOYEE'"

to this:

select count(*) as cnt

from all_tables

where owner = 'DEMO'

and table_name = 'EMPLOYEE'

View Code Statistics

Work with Code > Write Statements and Scripts > View Code Statistics

Toad can provide you with some basic statistics about your code.

Note: Because of the way the parser counts lines, the number of lines of code and blank or comment lines may vary. Use these statistics as an estimate rather than an exact count.

To view formatting statistics

  1. Open the code in the Editor.
  2. Right-click and select Formatting Tools | Profile Code.

 

Work with the Query Builder

Work with Code

Toad provides an intuitive and efficient way to write, run, and test your SQL and PL/SQL code. Toad supports efficient code management for a single developer or a whole team of developers.

 

About the Query Builder

Note: You can also select Database | Report| Query Builder.

Related Documents