Re: here's a good one from dizwell on the recent product launch

Mark Townsend wrote:
>

>>
>> I looked at this one tonight. The problem boils down to the following 
>> reproducible case
>>
>> select 1 from dual
>> where ('Tout' = CASE 'Oui'
>>         WHEN 'Oui' THEN 'Y'
>>         WHEN 'Non' THEN 'N'
>>         ELSE 'Tout' END)
>> /
>>
>> Exactly as this - i.e it has to be literals used in this manner, with 
>> this outcome.
>>

Great:

CREATE FLASHBACK ARCHIVE cdos
TABLESPACE flasharc
QUOTA 1 P
RETENTION 30 YEAR; ALTER TABLE townsend FLASHBACK ARCHIVE cdos;

> In a past life before Oracle I wrote language compilers in PL/1.
>
> PL/1 allowed you to define literals that were also part of the reserved
> word list for the language itself. So compiler code that read as
> followed was entirely possible
>
> If if = if then then = then else then = else.

No doubt PLW-06010 was written with you in mind.

Note: Anyone interested in the FLASHBACK ARCHIVE syntax,above, will find it released by Oracle at:
http://www.oracle.com/technology/products/database/oracle11g/pdf/flashback-data-archive-whitepaper.pdf and a demo you can run when you get 11g is at: http://www.psoug.org/reference/flash_archive.html

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org