LIST TABLES

Use LIST TABLES to list all tables in the database that match the specification provided with the command argument. Use the DBLOGIN command to establish a database connection before using this command. If logging into an Oracle multitentant container database, log in to the pluggable database that contains the tables that you want to list.

Syntax

LIST TABLES table

table: The name of a table or a group of tables specified with a wildcard (*).

Example

The following shows a LIST TABLES command and sample output.

list tables tcust*

TCUSTMER
TCUSTORD