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_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.
Date: Wed, 13 Aug 2003 00:23:33 GMT
Message-ID: <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 Wed Aug 13 2003 - 02:23:33 CEST