Re: spaces in fields name

From: <shiling_at_math.wayne.edu>
Date: Mon, 07 Jun 1999 18:15:09 GMT
Message-ID: <7jh274$u5p$1@nnrp1.deja.com>

Sure, you use double quotes. Here is an example.

SQL> create table t
  2 ("this is first column" date);

Table created.

SQL> desc t

 Name                            Null?    Type
 ------------------------------- -------- ----
 this is first column                     DATE

SQL> insert into t
  2 values
  3 (sysdate);

1 row created.

SQL> select "this is first column" from t;

this is f

---

07-JUN-99 SQL> In article <7jgk77$s65$1_at_gatekeeper.ornano.kapt.com>,   "Fred Ruffet" <fruffet_at_kaptech.com> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jun 07 1999 - 13:15:09 CDT