Re: what's the command to list all the tables in the DB

2001-05-29 Thread Rolf Hopkins
48 Subject: what's the command to list all the tables in the DB > Previously, I used "SELECT table_name FROM tabs" to get all the table names, but now, I logged into a new box using SQLPlus, but there is no record in the tabs table. So, how can I get the table nam

what's the command to list all the tables in the DB

2001-05-29 Thread Zhu George-CZZ010
Previously, I used "SELECT table_name FROM tabs" to get all the table names, but now, I logged into a new box using SQLPlus, but there is no record in the tabs table. So, how can I get the table names in that database (Oracle)? Thanks! -