RE: Using a '.' in a username

Last time I looked in my ANSI SQL standard usernames and object names were suppose to be :

1. Upper case
2. Could not contain punctuation characters
3. Could not contain spaces
4. etc...

But as always Oracle has allowed these "exceptions" so long as they are imbedded in double quotes which make them a pain in the a&& to work with. I believe Oracle did this to be "all inclusive". If you a database engine vendor you really don't want to say no to anybody. Kinda market limiting!!

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Monday, December 15, 2003 12:35 PM To: Multiple recipients of list ORACLE-L

Thanks, Vladimir. I haven't looked in the manual but as I've said, using those things in usernames or table names is a cruel and unusual practice which should be avoided if possible. On 12/15/2003 12:04:26 PM, Vladimir Begun wrote:
> Mladen Gogala wrote:
> > To use "." in the username is a cruel and unusual practice
> > which exposes funny sqlplus behavior:
> > $ sqlplus "test.yogi"
>
> Mladen, please have a look
>
> 1. It's not sqlplus but $SHELL behavior, try this
> $ sqlplus \"test.yogi\"
>
> 2. Oracle9i SQL Reference Release 2 (9.2)
> CREATE USER
>
> 3. Oracle9i SQL Reference Release 2 (9.2)
> Schema Object Naming Rules
>
> Schema Object Naming Examples
>
> The following examples are valid schema object names:
>
> last_name
> horse
> hr.hire_date
> "EVEN THIS & THAT!"
> a_very_long_and_valid_name
> --
> Vladimir Begun
> The statements and opinions expressed here are my own and
> do not necessarily represent those of Oracle Corporation.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Vladimir Begun
> INET: vladimir.begun_at_oracle.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Mladen Gogala
Oracle DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Goulet, Dick
  INET: DGoulet_at_vicr.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).