Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: User names starting with numeric

Re: User names starting with numeric

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 07 Oct 2004 21:34:38 -0700
Message-ID: <1097210161.786535@yasure>


Jon Smith wrote:

> 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

You can do it as indicated by others. But you would be far smarter to trot out the Oracle documentation that says you can't and not. Next they'll want mixed case column names and column names with spaces in them.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Thu Oct 07 2004 - 23:34:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US