Newsgroups: comp.databases.oracle.server
Subject: Re: MySQL -> Oracle
References: <slrn8umch0.k68.markku.s@sirppi.helsinki.fi>
Organization: GTE/BBN Technologies
From: jglockli@bbn.com (Jim Glockling)
Lines: 13
Message-ID: <79IG5.12$M16.299@burlma1-snr2>
X-Trace: /wmC6FhN3EQN8PxLNC4Kh6lVlrzFOjnzc87iF0872IvmSN104Tp2YROqn+Tj6f5PGkdJyejnZ1nq!jY87dpZJu6JFa7YSw+2gQrhbjUhYcA5G+JRBE2PvJUSDRZ+BrfadY9TGuzEM
X-Complaints-To: abuse@gtei.net
X-Abuse-Info: Please be sure to forward a copy of ALL headers
X-Abuse-Info: Otherwise we will be unable to process your complaint properly
NNTP-Posting-Date: Mon, 16 Oct 2000 18:53:55 GMT
Distribution: world
Date: Mon, 16 Oct 2000 18:53:56 GMT


In article <slrn8umch0.k68.markku.s@sirppi.helsinki.fi> mstrandm@_MOI_helsinki.fi writes:
>Hi. I've used mysql before and now I have to do some oracle stuff. Which
>would be equivalents of mysql's SHOW TABLES and SHOW COLUMNS FROM table?


"desc <table>" or "describe <table>" work fine for both mysql and oracle. These are
the equivalent of "show columns from <table>".

"select tablename from user_tables" is probably the closest general answer to 
"show tables".  There's more to it than that though, you might want to pick up a 
copy of the Oracle Complete Reference manual.

-Jim G.