Beta Released (12.10.0.23)

Toad for Oracle - Beta
1

Beta Notes
Code Analysis Rule 2750 False Positive
Code Analysis Rule 2750 (“List columns explicitly in your INSERT statement”) : False positive on INSERT statements with a record type VALUES clause. For instance,

CREATE OR REPLACE PROCEDURE T3E (p IN OUT t3%ROWTYPE) IS BEGIN    p.a := 3; INSERT INTO t3 VALUES p; -- okay (record type) END;

Formatter Chinese Options screen
In the Chinese version of the Options screen, selecting the Newline and DDL Statement panes did cause a nagging prompt “Attempted an unsupported operation”, due garbled layout of some controls on those panes.

New Code Analysis Rule 6417
Code Analysis: New Rule 6417 (“Avoid natural joins.”)

String ‘–’ inside a hint
A ‘–’ string inside a /*+ ... */ style hint causes Oracle to choke. This is the case in both Oracle 9i and 12g. The parser will now mimic this bug and yield an error “Oracle does not allow the string ‘–’ in a hint”.

Terminator with SET BLANKLINES OFF
When setting SET SQLBLANKLINES OFF a terminating blank line caused a non-terminating semicolon to be seen as a terminator.

2

Correction Update: Code Analysis Rule 6417 was not added to this beta as mentioned in the notes.

3

French characters are not being displayed properly.

Thanks

Best Regards … Sajjad

Mozein Sajjad |
Director, Application Development Main: 626.470.2845 | Cell: 310.817.9624

mozein.sajjad@tetratech.com

Tetra Tech | Complex World, Clear Solutions www.tetratech.com
| NASDAQ:TTEK 3475 E. Foothill Blvd. | Pasadena, CA 91107

From: Dennis Paulus [mailto:bounce-Dennis_Paulus@toadworld.com]

Sent: Tuesday, August 23, 2016 10:27 AM

To: toadoraclebeta@toadworld.com

Subject: [Toad for Oracle - Beta Discussion Forum] Beta Released (12.10.0.23)

Beta Released (12.10.0.23)

Thread created by Dennis Paulus

Beta Notes

Code Analysis Rule 2750 False Positive

Code Analysis Rule 2750 (“List columns explicitly in your INSERT statement”) : False positive on INSERT statements with a record type VALUES clause. For instance,

CREATE OR REPLACE PROCEDURE T3E (p IN OUT t3%ROWTYPE) IS BEGIN    p.a := 3;     INSERT INTO t3         VALUES p;          -- okay (record type) END;

Formatter Chinese Options screen

In the Chinese version of the Options screen, selecting the Newline and DDL Statement panes did cause a nagging prompt “Attempted an unsupported operation”, due garbled layout of some controls on those panes.

New Code Analysis Rule 6417

Code Analysis: New Rule 6417 (“Avoid natural joins.”)

String ‘–’ inside a hint

A ‘–’ string inside a /*+ ... */ style hint causes Oracle to choke. This is the case in both Oracle 9i and 12g. The parser will now mimic this bug and yield an error “Oracle does not allow the string ‘–’ in a hint”.

Terminator with SET BLANKLINES OFF

When setting SET SQLBLANKLINES OFF a terminating blank line caused a non-terminating semicolon to be seen as a terminator.

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - Beta Forum notifications altogether.

Toad for Oracle - Beta Discussion Forum

Flag
this post as spam/abuse.