Formatting Code (Ctrl+Shif+F)

Toad for Oracle - Beta
1

Good afternoon

After applying the formatting of the WITH statement some columns do not align.

Windows 10 64b
Toad for Oracle 64b
17.0.195.1287

format-toad
format-toad744×468 32.9 KB

Formatter - Align Column Aliases - measures bytes, not chars
2

Hi Carlos,

Can you post the entire SQL? It might help Andre (the Formatter Guy)

Thanks

John

3

llena-stage-prima.sql (15.7 KB)

4

Clearly due to the accented characters, for instance:

image

To be fixed. (QP-4114)

Thanks,
Andre

1 Like
5

FYI this was fixed in component QP5.dll version 5.402, released on Oct 10 2023.

6

Hi!
I get a syntax check error when formatting this query:

select jt.*
  from dual l, json_table('[{"rn":1},{"rn":2}]', '$[*]' columns(rn  integer path '$.rn')) jt;

[Error] Syntax check (2: 69): ERROR: line 2, column 69, ending line 2, column 75: Found 'integer': Expecting: )  ,   -or-   EXISTS  FORMAT  PATH   -or-   BLOB  CLOB  DATE  FOR  identifier  NUMBER  SDO_GEOMETRY  substitution_variable  TIMESTAMP  VARCHAR  VARCHAR2
[Error] Syntax check (2: 69): ERROR: line 2, column 69, ending line 2, column 75: Found 'integer': A reserved word cannot be used as an identifier
7

Hi Tenorio, can I kindly ask you to open a new thread for a new topic please?
Thanks