Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: User names starting with numeric
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