RE: Re: PL/SQL Interpreter oddity - bug or "expected"?

Each of these are just examples where the reserved word dictionary doesn’t keep up with the key word dictionary that are in use in ANSI or in specific databases.      

Matthew Parker

Chief Technologist

Dimensional DBA

Oracle Gold Partner

425-891-7934 (cell)

D&B 047931344

CAGE 7J5S7 Dimensional.dba_at_comcast.net <mailto:Dimensional.dba_at_comcast.net>

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn

www.dimensionaldba.com <http://www.dimensionaldba.com/>    

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Sayan Malakshinov Sent: Saturday, March 17, 2018 9:08 AM
To: Stefan Knecht <knecht.stefan_at_gmail.com> Cc: Matthias Rogel <rogel_at_web.de>; oracle-l-freelists <oracle-l_at_freelists.org> Subject: Re: Re: PL/SQL Interpreter oddity - bug or "expected"?  

:D In addition SQL examples with special words: http://orasql.org/2014/02/21/friday-prank-select-from-join-join-join/

select the join from join join join using(the,some)

/

select some join from left join join right using(some,the)

/

select 1 join from join join join join join using(the) on 1=1

/

with the(some) as (select * from dual the) select the(select some from the) from the where some = the(select * from the)

/
 

-- 

Best regards,
Sayan Malakshinov

http://orasql.org



--
http://www.freelists.org/webpage/oracle-l