Is an option to update Toad for Oracle 12.9.0.71 to use Oracle 12.2 syntax?

Toad for Oracle
1

Is there away to update/change syntax version to be Oracle 12.2 instead of 11?

Or if it is support in different version of Toad for Oracle?

Thanks!

2

I don't have the release dates in front of me for Oracle 12.2 and Toad 12.9, but if Toad 12.9 came out first, then it's not going to support Oracle 12.2 syntax. You'd have to update your Toad to get that.

You could, however, change the syntax highlighting in Options -> Editor -> Font and Styling, if you want to add colorization of some keyword, for example....

3

Thanks John for quick respond.

For now it is showing as invalid syntax e.g. LISAGG(col, ', ' ON OVERFLOW TRUNCATE) and refused to format so... I was just curious if there is a workaround.

4

Oh, to fix that, you'll need to update Toad. If you send me your full query I'll test it to make sure that it formats in the current version. You can send it in a private message if you don't want to post it for the world to see.

5

Thanks. Yes, it would be great if you could let me know Toad version # to upgrade to.

Query could be something simple with overflow trnc.

SELECT
LISTAGG(col1, ',' ON OVERFLOW TRUNCATE) WITHIN GROUP(
ORDER BY
col2
)
FROM
table1;

6

It formats correctly in the current version (13.2) which came out yesterday. Update to 13.2 if you can.

I did not try each version in between 12.9 and 13.2, but I also tried 12.12, and it formats correctly in that version also.

7

Thank you John for the info.

1 Like
8

One dummy question ... is it now "Quest Toad for Oracle" or "Dell Toad for Oracle"?

Just wanted to identify to request new version (at my company).

9

Quest. We are no longer a part of Dell.

1 Like