Re: User names starting with numeric

From: Hans <forbrich_at_gmail.com>
Date: 7 Oct 2004 09:03:43 -0700
Message-ID: <bd0e88c6.0410070803.696805c0@posting.google.com>

"Jon Smith" <usenet123_at_ntlworld.com> wrote in message news:<4164ef97$0$94923$5a6aecb4_at_news.aaisp.net.uk>...
> We want to create oracle users to correspond to other accounts we have on
> other systems. These include user names starting with numeric number e.g.
> 123abc. I have tried creating these and oracle rejects the name, but accepts
> it if it is enclosed in double quotes. Is this okay.
>
> Thanks Jon

Leading numeric in a name is not permitted without overriding acceptable behaviour using double quotes.

This (and the remaining rules and gotchas around user - in fact any identifier) is clearly documented in the SQL Reference manual under the CREATE USER command, which points to http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/sql_elements9a.htm#27571

/Hans Received on Thu Oct 07 2004 - 11:03:43 CDT