What are the guidelines for naming an Oracle database table?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

What are the guidelines for naming an Oracle database table?

Rating:

Following are the guidelines for naming an Oracle database table:

  • A table name must begin with a letter.

  • A table name must be one to thirty characters long.

  • A table name must not be an Oracle Server reserved word.

  • A table name must contain only A-Z, a-z, 0-9, _, $, and #.

  • A table name must not duplicate the name of another object owned by the same Oracle Server user.


    • Note: Table names are case insensitive.


    Rating:



    Other articles

    Click here to Article home

    MCSE: MCSA, MCTS, MCITP    JAVA Certification: SCJP, SCWCD Cisco Certification: CCNA, CCENT, A+, Network+, Security+

    Oracle Certification: OCP 9i, OCP 10g, OCA 9i, OCA 10g, 1Z0-040: Upgrade to OCA 10g Fundamentals I, Oracle Fundamentals II, Admin I, Oracle Admin II, PL/SQL CIW foundation    Photoshop ACE
    © 2008 uCertify.com. All rights reserved. All trademarks are the property of their respective owners.
     
    HACKER SAFE certified sites prevent over 99.9% of hacker crime.