-
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
-
I remember when this place was cool.
-
Surround the name in double-quotes, then shoot the person who created them like that.
-
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
-
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.
-
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!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|