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

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-l