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

Originally posted by Alex

> 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"]news:9yf_a.1-
> 87707$xg5.28800_at_twister.austin.rr.com[/url]...

> > 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

What is the error message that was thrown before and after using "" Plus Oracle version. It's like shooting in the dark without proper info.

Regards

/Rauf Sarwar

--
Posted via http://dbforums.com