Home » Other » General » Oracle (or industry) naming conventions for VIEWS. Is there a standard? (Oracle 11g)
Oracle (or industry) naming conventions for VIEWS. Is there a standard? [message #597557] Sun, 06 October 2013 09:10 Go to next message
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?
icon2.gif  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 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
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 Go to previous message
rc3d
Messages: 213
Registered: September 2013
Location: Baden-Württemberg
Senior Member
thank you guys
Previous Topic: Concern with Application team
Next Topic: merge
Goto Forum:
  


Current Time: Thu Mar 28 09:10:33 CDT 2024