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 Bortel
Received on Sat Aug 16 2003 - 07:09:13 CDT
