Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to reference table/view that has "slashes" in its name!
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 Received on Tue Aug 12 2003 - 19:23:33 CDT