Re: newbie question??

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Tue, 15 Apr 2003 11:25:10 +0200
Message-ID: <b7gj8g$mg39$1@ID-152732.news.dfncis.de>

"kent" <kent_at_com.com> schrieb im Newsbeitrag news:b7ghks$n24$1_at_hfc.pacific.net.hk...
> how to display all the schema like "show databases" in myql?

select * from dba_users;

> how to display all the tables like "show tables" in mysql?

select * from dba_tables where owner = 'SCOTT'; or as user SCOTT
select * from user_tables;

>

and next time read more first at tahiti.oracle.com, how to query the data dictionary ;)

hth, Jan Received on Tue Apr 15 2003 - 04:25:10 CDT