Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: H E L P!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
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
![]() |
![]() |