Re: spaces in fields name

Sure you can. All you need to do is inclose the field in double-quotes each time you reference it. You will also need to make sure the case is the same as it appears in the describe table.

select "First Name", "Last Name"
from customers;

Kenny Gump
OCP 7.3 DBA Fred Ruffet wrote in message <7jgk77$s65$1_at_gatekeeper.ornano.kapt.com>...
>If I get spaces in my fields names, can I use them in SQL*plus and how ?
>
>Thanks for any help,
>
>Frédéric Ruffet - fruffet_at_kaptech.com
>"Seach for perfection is all very well,
> But to look for Heaven, is to leave here in hell." G.M.Summer
>
>
>
Received on Tue Jun 08 1999 - 06:42:56 CDT