Sql = " select count(*) as cnt"
Sql = Sql & " from all_tables"
Sql = Sql & " where owner = 'DEMO'"
Sql = Sql & " and table_name = 'EMPLOYEE'"
select count(*) as cnt
where owner = 'DEMO'
and table_name = 'EMPLOYEE'
View Code StatisticsWork 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
- Open the code in the Editor.
- Right-click and select Formatting Tools | Profile Code.
Work with the Query BuilderWork 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.