RE: Reserved word? or not?

From: Clarke, Andrew <>
Date: Wed, 24 Sep 2008 10:52:48 +0100
Message-ID: <>

> Er isn't that SQL not PLSQL?

Fair point well made. However, wrapping it in PL/SQL doesn't seem to make any difference....

  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.

SQL> So I think it must be something peculiar in the specific details of Jack's program.

Cheers, APC

A P Clarke
Software Architect
Logica UK Public Sector Division
Stephenson House
75 Hampstead Road
Direct Tel: +44 (0)207 230 3160
Fax: +44 (0)207 446 1352

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.

Received on Wed Sep 24 2008 - 04:52:48 CDT

Original text of this message