Rules for Oracle 10g schema object names

Source: Internet
Author: User

Rule 1 for Oracle 10g schema object names) except for the database link name, the schema object name can contain a maximum of 128 characters and a maximum of 30 characters. 2) reserved words (such as SELECT) cannot be used as object names. 3) All names must start with A letter from A to Z. 4) The name can only contain letters, numbers, underscores (_), and dollar signs ($) hash symbols (#). 5) lowercase letters are converted to uppercase letters. If the name is enclosed in double quotation marks, you do not need to follow all the above rules (except for the name length). However, when obtaining such an object, you must always use double quotation marks to specify the object. Note that the same constraints apply to the column names. Object names are case sensitive.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.