Oracle: Show Tables – SQL*Plus

Tables are the basic unit of data storage in Oracle databases. In this note i will show how to list all tables in an Oracle database (equivalent to SHOW TABLES command in MySQL) using the command-line interface of SQL*Plus. I will also show how to list only tables owned by the current user, show the […]