Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    1

    Unanswered: What is the maximum length for the Table name

    Hello,

    I am new to oracle.

    Is there any restriction on the number of characters used in the table name in Oracle.

    I was thinking I can go up to 255 characters. Let me know.

    Also is spaces allowed between characters with in column and table name??

    TIA,
    Rajiv

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: What is the maximum length for the Table name

    30 characters is the maximum for table and column names, and you should not use spaces - underscores (_) are a popular alternative. Actually, it is possible to use spaces but only if you always enclose the name in double quotes whenever you use it:

    create table "my table" ( "my id" integer );

    My strong advice would be never to do that. In addition to requiring the double quotes whenever referenced, these names are also now case sensitive, so this won't work:

    SELECT * FROM "MY TABLE";

    The full details can be found in the Oracle SQL Reference.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •