If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script:

SQL> connect HR/globalguideline

Connected.

SQL> SELECT table_name, status, num_rows FROM USER_TABLES;

TABLE_NAME    STATUS  NUM_ROWS

------------------------------ -------- ----------

REGIONS    VALID   4

LOCATIONS    VALID  23

DEPARTMENTS    VALID  27

JOBS     VALID  19

EMPLOYEES    VALID   107

JOB_HISTORY    VALID  10

COUNTRIES    VALID  25

7 rows selected.