Re: MySQL -> Oracle

On 16 Oct 2000 16:51:44 GMT, markku.s_at_usa.net (Markku S) wrote:

>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?

select * from user_tables; (or dba_tables if you have the privs)

and

desc table_name; Received on Mon Oct 16 2000 - 17:02:21 CDT