Using mixed case for table and column names
Posted on 2008-10-17
We're used to developing systems for MS-SQL, and our standards have grown up around using mixed case identifiers--tables and columns--as allowed in MS-SQL. We have a new project that is using an Oracle back-end, and we're discovering that our standards don't play so well in the Oracle world. Mixed-case seems to be allowed, but it seems that our queries will have to make extensive use of double-quotes to accommodate this.
Can someone please summarize (or point me to) some current object naming standards for Oracle development work? Thank you in advance!