RE: Re: PL/SQL Interpreter oddity - bug or "expected"?
Date: Sat, 17 Mar 2018 11:58:25 -0700
Message-ID: <018d01d3be21$ee275670$ca760350$_at_comcast.net>
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-lReceived on Sat Mar 17 2018 - 19:58:25 CET