Re: How to reference table/view that has "slashes" in its name!

Thank you all for your help. I've tried your suggestions (double quotations, caps, etc) but none seem to work. I think I'll try to find the person who created these objects and see if he has a solution.

Thanks again,

Alex

"Alex" <sh2222_at_yahoo.com> wrote in message news:9yf_a.187707$xg5.28800_at_twister.austin.rr.com...
> 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 Thu Aug 14 2003 - 18:49:38 CDT