Re: can i use "Telephone Number" as a filed name having a space in it ....does there exist quoted identifiers

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Thu, 26 Nov 1998 00:46:08 GMT
Message-ID: <365ca4c6.1717309@192.86.155.100>

A copy of this was sent to pierobon_at_netcom.ca (if that email address didn't require changing) On Wed, 25 Nov 1998 19:37:53 -0400, you wrote:

>can i use "Telephone Number" as a filed name having a space in it
>....does there exist quoted identifiers
>in oracle 8 as does sql server 7?
>
>-vic
>
>

Yes

SQL> create table demo ( "Telephone Number" number );

Table created.

SQL> desc demo

 Name                            Null?    Type
 ------------------------------- -------- ----
 Telephone Number                         NUMBER

SQL>   Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Wed Nov 25 1998 - 18:46:08 CST