DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2001
    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
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.