Re: Yet another small question....

Try

        SELECT table_name FROM all_tables;

Regards

Jerry

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
Received on Mon Feb 23 1998 - 00:00:00 CST