Some people have already mentioned the answer but forgot to mention one point. If you do a
select owner, table_name from user_tables; It will show you all the tables you have access to, not necessarily ones owned by you. If you want to see tables you have created add a where clause WHERE owner = 'YOUR NAME' If you want to see all the tables in the database use dba_tables but you'll need to be granted access to it. Dave > > From: "Anil Garg" <[EMAIL PROTECTED]> > Date: 2003/03/17 Mon PM 12:34:32 EST > To: <[EMAIL PROTECTED]> > Subject: oracle. > > hi, > > m a frequent user of mysql. > i was trying to use "show tables" on oracle(sql>), but it dint work :( > How do list tables in oracle? > > Thanks > anil. > p.s. sorry for the out of list question. > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php