Re: What is the meaning of # and $ characters in database object names?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 2 Oct 2006 14:06:55 -0700
Message-ID: <1159823215.065917.82690@c28g2000cwb.googlegroups.com>

Mike wrote:
> Just wondering what the meaning is of $ and # signs in database
> object names. Whats in the name right, you can call an object what
> you want, but what is the reason that certain SYS objects and
> certain application schema objects have been given names like EMP#,
> CATALOG$ by the developers.

Lots of potential reasons including some people that might have felt they were saving space in system data dictionary tables and fixed tables.

Other times just people that didn't want to type any more than that.

Once something goes out in a release it becomes hard to do maintenance and make changes to names because of other internal and external dependencies. Received on Mon Oct 02 2006 - 16:06:55 CDT