DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Table names showing up in lower case

  1. #1
    Join Date
    Feb 2001
    Posts
    6
    I have some table names showing up in lower case
    when I issue a select from dba_tables or dba_objects.
    When I try and select data from them i get an error
    saying they are unrecognized. Any ideas. How does
    a table or object get created as case sensitive in the
    database? I thought it forced all object names to
    upper case.

  2. #2
    Join Date
    Jul 2000
    Posts
    296
    If you have object names in lower case, use " around the name:

    SELECT * FROM "your_table";

    This is also the way to create (and drop) objects in lower case.
    CREATE TABLE "tab"
    ( col NUMBER
    );

    DROP TABLE "tab";

    As fas as i know tables migrated from Access can get created in lower case.


Posting Permissions

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


Click Here to Expand Forum to Full Width