Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Select statement - to help with

Re: Select statement - to help with

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Thu, 23 Dec 2004 21:21:43 -0800
Message-ID: <41cba65f$1_2@127.0.0.1>


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

Au contraire mon ami: I posted the DDL.

-- 
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:21:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US