Re: MySQL -> Oracle

From: Jim Glockling <jglockli_at_bbn.com>
Date: Mon, 16 Oct 2000 18:53:56 GMT
Message-ID: <79IG5.12$M16.299@burlma1-snr2>

In article <slrn8umch0.k68.markku.s_at_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. Received on Mon Oct 16 2000 - 13:53:56 CDT