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: H E L P!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Re: H E L P!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

From: Stephane Faroult <sfaroult_at_oriolecorp.com>
Date: Mon, 12 Apr 1999 19:18:40 -0700
Message-ID: <3712A980.7B29@oriolecorp.com>


Genna wrote:
>
> I'm creating a table. Anyone know i can create the table using
> the '#' sign?

> #_of_people Number,

You can ... if it's not in first position (same thing with _). Identifiers must start with a letter. You can however work around this by enclosing the name between double quotes, but it will mean you shall have to refer to "#_of_people" (with the double quotes) everywhere in your queries (becomes quickly boring).
If it's just a matter of having something meaningful in a .sql script, you can also call your column

   people_count number

and do either

    select people_count "# of people", .... from ... or

    column people_count heading '# of people'     select people_count, ... from ...

--
Regards,

  Stéphane Faroult
  Oriole Corporation



http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
Received on Mon Apr 12 1999 - 21:18:40 CDT

Original text of this message

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