Re: Double words in the table name

From: VasantKumar Naidu <vask001_at_yahoo.com>
Date: 20 Feb 2003 03:45:54 -0800
Message-ID: <d9a73221.0302200345.30e48a9c_at_posting.google.com>


kenny,

as far as i know oracle does not allow spaces in table names (i haven't used one so far... but should be possible). many of the characters are also not allower except the "$" and "#" symbols. you can check out the documentation for the SQL statements at the oracle site

vasant

kennypoon <member6892_at_dbforums.com> wrote in message news:<2551480.1045710948_at_dbforums.com>...
> In SQL Server, when you have a table name which have two or more words,
> you need to use double quota in the SQL statement:
> Select * from "table 123"
>
> is it same in Oracle? or Oracle don't permit have two or more words in
> the table name or field name?
Received on Thu Feb 20 2003 - 12:45:54 CET

Original text of this message