RE: Re: PL/SQL Interpreter oddity - bug or "expected"?
Date: Sat, 17 Mar 2018 12:09:18 -0700
Message-ID: <019c01d3be23$738bc930$5aa35b90$_at_comcast.net>
From the docs key words versus reserved words.
https://docs.oracle.com/database/121/SQLRF/ap_standard_sql003.htm#SQLRF55516
“an Oracle reserved word (the list of Oracle reserved words differs from the standard's list)”
https://docs.oracle.com/database/121/SQLRF/ap_keywd002.htm#SQLRF55622
“Oracle SQL keywords are not reserved. However, Oracle uses them internally in specific ways. Therefore, if you use these words as names for objects and object parts, then your SQL statements may be more difficult to read and may lead to unpredictable results.
You can obtain a list of keywords by querying the V$RESERVED_WORDS data dictionary view. All keywords in the view that are not listed as always reserved or reserved for a specific use are Oracle SQL keywords. Refer to <https://docs.oracle.com/database/121/REFRN/GUID-6D03E5B5-A23B-499C-B6BC-A31A12FC6C7D.htm#REFRN30204> Oracle Database Reference for more information.”
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 Matthew Parker
Sent: Saturday, March 17, 2018 11:58 AM
To: xt.and.r_at_gmail.com; '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"?
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 <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto: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 <mailto:knecht.stefan_at_gmail.com> >
Cc: Matthias Rogel <rogel_at_web.de <mailto:rogel_at_web.de> >; oracle-l-freelists <oracle-l_at_freelists.org <mailto: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 - 20:09:18 CET