OraFAQ Forum: General » Oracle (or industry) naming conventions for VIEWS. Is there a standard?

Home » Other » General » Oracle (or industry) naming conventions for VIEWS. Is there a standard? (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle (or industry) naming conventions for VIEWS. Is there a standard? [message #597557]

Sun, 06 October 2013 09:10

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

Hi

I create a lot of Views. Is there an industry standard naming convention? Every company have their own naming convention?

What does Oracle recommend?

Report message to a moderator

Re: Oracle (or industry) naming conventions for VIEWS. Is there a standard? [message #597558 is a reply to message #597557]

Sun, 06 October 2013 09:13

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Every company have their own naming convention?

Yes.

Quote:

What does Oracle recommend?

The only things it recommends are:
1/ Do not use other characters than A-Z0-9_$# (upper case only) and start with one of A-Z
2/ Do not use a name from V$RESERVED_WORDS view

[Updated on: Sun, 06 October 2013 09:15]

Report message to a moderator

Re: Oracle (or industry) naming conventions for VIEWS. Is there a standard? [message #597559 is a reply to message #597557]

Sun, 06 October 2013 09:54

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

You can search for the documentation on "Naming Standards".

Here is also a good explanation by Tim Hall on Oracle Naming Conventions

Regards,
Lalit

Report message to a moderator

Re: Oracle (or industry) naming conventions for VIEWS. Is there a standard? [message #599568 is a reply to message #597559]

Sat, 26 October 2013 03:10

rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg

Senior Member

thank you guys

Report message to a moderator

Previous Topic:	Concern with Application team
Next Topic:	merge

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 08 15:26:54 CST 2025