Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to reference table/view that has "slashes" in its name!
"Alex" <sh2222_at_yahoo.com> wrote:
>I'm new to Oracle, so this question may sound silly. I have been given a
>list of Oracle tables (they may be views, I'm not sure) that are available
>to me. I can run simple SQL select statements against most of them in SQL
>Plus. But some of them have "slashes" in their names such as /XYZ/CUSTOMERS
>or /XYZ/ADDRESSES . When I try to use the name the way it's listed (with
>slashes) I get an error. I even tried replacing the slashes with dots, but
>that didn't work either. My question is how do I reference a table/view (in
>a SQL select statement for instance) that has slashes in its name. I'm not
>sure if this is relevant, but I think the Oracle database runs on a Unix
>box. Thanks in advance.
>
>Alex
>
In addition to all the good advice you have been given about using " " to enclose the badly formed name, speak to the DBA who
created such a non-compliant piece of S*** .
There is no reason to make users jump through hoops because of a lack of Oracle knowledge - If it was a purchased app that
did it, ask for your money back - who knows what other non-standard stuff may be hidden in the coding.
Received on Wed Aug 13 2003 - 10:51:20 CDT