Toad World® Forums

Toad 12 won't run 12c syntax reliably with ;


#1

The queries using the 12 MATCH_RECOGNIZE clause don’t work with F9 or F5 if there is a semi-colon statement terminator; but will work with Ctrl+Enter

http://technology.amis.nl/wp-content/uploads/2013/07/mostValuablePlayer.txt

In particular

with player_actions as

( select me.match_id

, me.seq

, me.player

, case me.team

     when 'A' then m.team_a

     when 'B' then m.team_b

     end team

, me.action

from match_events me

     join

     matches m

     on (me.match_id = m.id)

)

select match_id

, mr.match_num

, mr.seq

, mr.team

, mr.player

from player_actions

match_recognize

(

partition by match_id

ORDER BY seq

MEASURES MATCH_NUMBER() AS match_num

ALL ROWS PER MATCH

AFTER MATCH SKIP TO LAST GOAL

 PATTERN (POSSESSION+ GOAL)

 DEFINE

   POSSESSION AS POSSESSION.team = FIRST(POSSESSION.team),

   GOAL AS GOAL.action='G' and GOAL.team = POSSESSION.team

) MR;

fails with

ORA-00933: SQL command not properly ended

removing the semicolon works


#2

This has been fixed in Toads having QP5.dll version 5.258 or higher.

Thanks for reporting,

Andre


#3

How does one get QP5 updated?

I have 5.256


#4

It’s updated with each Toad release. Toad 12.1 includes version 5.257.

On 02/11/2014 01:01 PM, sdstuber wrote:

RE: Toad 12 won't run 12c syntax reliably with ;

Reply by sdstuber
How does one get QP5 updated?

I have 5.256

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


#5

The newer version of QP5 will be released with the 12.5 edition in the spring.


#6

I just caught Andre’s reply on the forum. I’m still getting used to this new email gateway that conveniently strips valuable messages that appear earlier in the thread. 5.258 would be a Toad 12.5 beta build. You’ll need to join the beta program or wait for
Toad 12.5 to be released.

Michael

On 02/11/2014 01:01 PM, sdstuber wrote:

RE: Toad 12 won't run 12c syntax reliably with ;

Reply by sdstuber
How does one get QP5 updated?

I have 5.256

To reply, please reply-all to this email.

Stop receiving emails on this subject.

Or
Unsubscribe from Toad for Oracle - General
notifications altogether.

Toad for Oracle - Discussion Forum

Flag
this post as spam/abuse.


No virus found in this message.

Checked by AVG - www.avg.com

Version: 2014.0.4259 / Virus Database: 3684/7045 - Release Date: 01/30/14

Internal Virus Database is out of date.