Toad: Count characters in SQL statement
Toad for Oracle 12:
I'm working in a system that has an unfortunate limitation where an SQL query's FROM clause can only have up to 1000 characters (including spaces). This becomes a problem when the FROM clause has a lengthy subquery in it (> 1000 chars).
So, when writing SQL in Toad, I need a way to highlight the SQL in the FROM clause and count the characters in the highlighted text, including spaces.
Currently, I copy the text into MS Word and do a character count there. That works, but it would be better if I could do the character count right in Toad.
Question:
Does Toad 12 have SQL character count functionality?
Solution
As @SamM mentioned, the bottom panel/status bar shows the character count when I highlight text in the SQL editor window:
- ORA-12170: TNS:Connect timeout occurred
- A column of my table is showing invalid identifier in toad
- Big speed difference for the same query executed on 2 different Oracle schemas
- Connect TOAD to Oracle using JDBC connection
- How to change Data Grid script output colors in TOAD?
- How to restore TOAD layout to its orginal layout?
- Indentation of code in Toad
- In TOAD, is there a way to comment out arbitrary blocks of code (i.e not whole lines)?
- Oracle password change, REPLACE being ignored
- Searching for Text within Oracle Stored Procedures
- Getting error on executing a procedure having dyinamic sql
- Oracle SQL update field in one table with another table using 'where' clause and 'exists' statement
- How to use SQL to filter a column to simultaneously 'equal to something' and 'not equal to something else'?
- Does TOAD for oracle generate logs of executed SQL?
- Connecting an oracle database to TOAD for Oracle using a Cloud Wallet
- Keep getting syntax error message in Toad Data Point
- ORACLE: SQL syntax to find table with two columns with names like ID, NUM
- Using SQL date Variable with TOAD
- Plsql stored procedure execution - how to monitor
- How to escape ampersand in TOAD?
- Oracle 19c/Toad - Need to display NULL and non-NULL values in the result set based on below requirement
- ORA-06502 with ORA-06512
- How to split a string with multiple characters into separate columns in SQL?
- 'Expansion' shortcuts (aka SQL templates?) in DBeaver
- How can I solve ORA-00911: invalid character error?
- Toad for Oracle 10.5.1.3 - How to find DataType info like in Schema Browser
- Why does Oracle not find oci.dll?
- Weird characters added to first column name after reading a toad-exported csv file
- Oracle SQL: CTE Query gives different results in TOAD, depending on how executed
- Not able to connect mysql db by toad on linux server which it is easily connected by putty or linux terminal?