Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to reference table/view that has "slashes" in its name!

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

From: Alex <sh2222_at_yahoo.com>
Date: Wed, 13 Aug 2003 00:23:33 GMT
Message-ID: <9yf_a.187707$xg5.28800@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 Tue Aug 12 2003 - 19:23:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US