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

Thread: funny table names

  1. #1
    Join Date
    Jan 2001
    Posts
    2,828

    funny table names

    Hi DBA's

    I need to select from tables but the tables names are funny like


    select count(*) from /BDL/BADHOST
    ERROR at line 1:
    ORA-00903: invalid table name

    tablenames are like
    /BDL/BADHOST

    how do i select from this table /BDL/BADHOST

    regards
    Hrishy

  2. #2
    Join Date
    Jan 2001
    Posts
    3,134
    ""
    I remember when this place was cool.

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Surround the name in double-quotes, then shoot the person who created them like that.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Originally posted by slimdave
    Surround the name in double-quotes, then shoot the person who created them like that.
    Would that be a DBA? Are you really advocating shooting a DBA?
    Code:
    At least he didn't name the tables
    (" ", "  ", "   ", "    ", "     ")! :D

  5. #5
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Originally posted by gandolf989
    Would that be a DBA? Are you really advocating shooting a DBA?
    Oh yeah, I'm very fair like that. DBA's, developers, analysts, users. whatever.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  6. #6
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Originally posted by slimdave
    Oh yeah, I'm very fair like that. DBA's, developers, analysts, users. whatever.
    Well as long as you are an equal opportunity basher.
    Just don't forget the BA's!

  7. #7
    Join Date
    Jul 2002
    Posts
    335
    Originally posted by slimdave
    Surround the name in double-quotes, then shoot the person who created them like that.
    Agreed. Also note you can create a table with just a number of spaces for its name, almost a hidden table. why on earth you'd want to, I don't know. One for the academics.

    Bazza

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