Vs: Re: Reserved word? or not?
Date: Wed, 24 Sep 2008 13:24:09 +0300
Yes, works for me also all versions 9i - 10.1 - 10.2 - 11.1.
But "language" is still a keyword and according to doc's should not be used... ;-)
>>> "Howard Latham" <howard.latham_at_gmail.com> 24.9.2008 13:15:28 >>>
Yes it runs for me too.
2008/9/24 Clarke, Andrew <andrew.clarke_at_logica.com>
> > Er isn't that SQL not PLSQL?
> Fair point well made. However, wrapping it in PL/SQL doesn't seem to make
> any difference....
> SSQL> r
> 1 declare
> 2 language my_table_ext.language%type;
> 3 begin
> 4 for lrec in ( select * from my_table_ext ) loop
> 5 language := upper(lrec.language);
> 6 if language = 'BABEL 17' then
> 7 dbms_output.put_line('Hello Tarek');
> 8 else
> 9 dbms_output.put_line('Hello world');
> 10 end if;
> 11 end loop;
> 12* end;
> Hello Tarek
> Hello world
> PL/SQL procedure successfully completed.
> So I think it must be something peculiar in the specific details of Jack's
> Cheers, APC
> A P Clarke
> Software Architect
> Logica UK Public Sector Division
> Stephenson House
> 75 Hampstead Road
> NW1 2PL
> Direct Tel: +44 (0)207 230 3160
> Fax: +44 (0)207 446 1352
> Email: andrew.clarke_at_logica.com
> This e-mail and any attachment is for authorised use by the intended
> recipient(s) only. It may contain proprietary material, confidential
> information and/or be subject to legal privilege. It should not be copied,
> disclosed to, retained or used by, any other party. If you are not an
> intended recipient then please promptly delete this e-mail and any
> attachment and all copies and inform the sender. Thank you.
-- Howard A. Latham -- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 24 2008 - 05:24:09 CDT