thanks, that helped anil :)
-----Original Message----- From: Nestor Florez [mailto:[EMAIL PROTECTED] Sent: Monday, March 17, 2003 12:51 PM To: Anil Garg Subject: Re: oracle. Anil, I do not remember correct but you need to look at the user_tables. 'desc user_tables' One of the fields mught be owner or something then you can do "select * from user_tables where owner='SCOTT';" Now, I am not 100% sure on htat command but you need to key on somethin gin the user_tables :-) -------Original Message------- From: Anil Garg <[EMAIL PROTECTED]> Sent: 03/17/03 09:34 AM 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: <a target=_blank href="http://www.mysql.com/manual.php">http://www.mysql.com/manual.php</a> (the manual) <a target=_blank href="http://lists.mysql.com/">http://lists.mysql.com/</a> (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: <a target=_blank href="http://lists.mysql.com/php/unsubscribe.php">http://lists.mysql.com/php /unsubscribe.php</a> > --------------------------------------------------------------------- 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