Re: Yet another small question....

try

select *
  from all_tables;

to get the list of user tables try
  select *
   from all_tables
Where owner = USER;

--Arvind
Jeppe Sverdrup Brynjulfsen wrote:

> I am used to the command
> SELECT * FROM user_tables; to list all the tables in the connected
> database. But I have no user_tables in the system. I thought there
> always was a user_tables in the database. How can I list up all the
> tables when I do not have a user_tables?
>
> Thank you very much, and have a nice day!
>
> **************************
> Jeppe Sverdrup Brynjulfsen
> jeppe.brynjulfsen_at_eunet.no
> Den Polytekniske Høyskolen

--
Balaraman Arvind
151 Andrew Ave, Apt 215
Naugatuck, CT 06770

ph   -  (203)-723-1190(R)
     -  (203)-459-7502(O)

mail -  dnivra_at_ix.netcom.com (R)
        abalaram_at_oxhp.com    (O)