Re: How to reference table/view that has "slashes" in its name!
From: Frank <fvanbortel_at_netscape.net>
Date: Sat, 16 Aug 2003 14:09:13 +0200
Message-ID: <bhl6ir$dsk$2_at_news2.tilbu1.nb.home.nl>
>>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
>>
Did you hear, Oracle?
Take a look at the Java classes...
Date: Sat, 16 Aug 2003 14:09:13 +0200
Message-ID: <bhl6ir$dsk$2_at_news2.tilbu1.nb.home.nl>
TurkBear wrote:
> "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. >
Did you hear, Oracle?
Take a look at the Java classes...
-- Regards, Frank van BortelReceived on Sat Aug 16 2003 - 14:09:13 CEST