Re: Space in database table's fields

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Tue, 3 May 2005 17:38:37 -0700
Message-ID: <wqWdnZlHcb_BhOXfRVn-rQ@comcast.com>

<sunny076_at_yahoo.com> wrote in message
news:1115166422.663134.79700_at_g14g2000cwa.googlegroups.com...
> Hi,
>
> I am wondering how Oracle deals with space in field(attribute) name? I
> am figuring out the syntax to for example use in SELECT Test Table FROM
> Test2, for example.
>
> I know in SQL we can put [] around the name of the field. Can anyone
> enlighten me?
>
> Sunny
>

1. SQL = Structured Query Language.  NOT MicroSoft's SQLServer.
2. You can't put [] around the field name in SQL.  It is NOT a standard.
3. It is not recommended to put spaces in field or table names.  Bad

practice.
4. If you insist on this then you must double quote the field or table names.

Jim Received on Tue May 03 2005 - 19:38:37 CDT