Funky query #2 (OracleScript doesn't parse properly)

[Peter Zolja]

If you pass this query to the Oracle script:

with q as (select 1 from dual)
select * from q

the script parser breaks it into two queries:

with q as (select 1 from dual)

-and-

select * from q

which, of course is not correct...

Now, if you pass it as a single line (no CRLF before the select) it works fine...

 

[Marco Kalter]

It seems to have a problem recognizing the WITH statement.

We'll fix it.