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

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

SQL> create table "ABC/def" ( x char(1) );

Table created.

SQL> select * from "ABC/def";

no rows selected

--
Billy