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
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 Builder
Work with CodeToad 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.
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center