nixCraft Linux Forum - View Single Post

nixcraft · #2 (**permalink**) 12-19-2006, 03:03 AM

To list all your tables in Oracle server, use the following command:

Code:

SELECT * FROM cat;

First connect to server using Oracle sql plus client:

Code:

sqlplus scott/tiger

Now type at sql> prompt:

Code:

SELECT * FROM cat;

Also don't forget to set the column widths

Code:

COL table_name FORMAT a30;
COL table_type FORMAT a30;

Now to get list of tables in oracle:

Code:

SELECT * FROM cat;