Re: Select statement - to help with

In article <41cba6e7$1_2_at_127.0.0.1>, DA Morgan says...
>
>yong321_at_yahoo.com wrote:
>
>> Denis Do wrote:
>>
>>>Hi Guys!
>>>
>>>Need your help:-)
>>>I have a query:
>>>
>>>SELECT TO_DATE('25-DEC-2004','DD-MON-RRRR') AS XMAS
>>>FROM 2004
>>>WHERE IS_MEMBER_OF_COMP_DATABASES_ORACLE_SERVER = 'YES';
>>>
>>>What type of drink should I use and what are right values
>>>of PCTFREE ad PCTUSED? :-)
>>>
>>>Merry Christmas to everyone, guys!
>>>Lets all our dreams come true in New Year as well.
>>
>>
>> Regardless the drink and table physical properties, you can't create a
>> table or view called 2004; you would get "ORA-00903: invalid table
>> name" or ORA-999 for invalid view name. You can't create a table column
>> named IS_MEMBER_OF_COMP_DATABASES_ORACLE_SERVER; you would get
>> "ORA-00972: identifier is too long".
>>
>> Merry Christmas.
>>
>> Yong Huang
>
>On reflection, or whatever, you are partially correct. But the issue
>is not the table name ... it is the column name's length. Perhaps the
>OP can short it to IS_MEMBER_OF_CDO_SERVER.

or use OR types

ops$tkyte_at_ORA9IR2> select TO_DATE('25-DEC-2004','DD-MON-RRRR') AS XMAS   2 from "2004" " "
  3 where " ".is_member_of.comp.databases.oracle.server = 'YES'   4 /  

no rows selected

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation