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.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------
http://www.newsfeed.com The #1 Newsgroup Service in the World!
-----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =-----
Received on Thu Dec 23 2004 - 23:23:59 CST
