This discussion is archived
1 2 Previous Next 15 Replies Latest reply: Apr 22, 2013 5:34 PM by Vite DBA Go to original post RSS
  • 15. Re: what case should be used while nameing objects.
    rp0428 Guru
    Currently Being Moderated
    >
    I wasn't advocating any particular case, my main point was that when reading the data dictionary, having an underscore as a word separator is preferable.
    >
    +1

    And this is just plain common sense, besides being good advice
    >
    Use whatever standard works for you in general code, but for database object names, use one case with underscores as word separators. EG

    TRANS_DTL_LINES_SEQ
    >
    My sentiments exactly!

    Besides the comment 'I personally don't like code that is all uppercase' isn't even relevant to what you said.

    An object or column name isn't 'code'; it is the name exactly as defined in the database. That is EXACTLY what should be used.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points