Re: Select statement - to help with

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 Received on Thu Dec 23 2004 - 22:18:03 CST