0
Thanks

A few words of thanks would be greatly appreciated.

How To List the Tables in an Oracle Database


Displaying the list of tables present in an Oracle database is quite easy to do.

If you'd like to do so but aren't sure how, look no further than this tutorial. See below for the necessary steps.

Display the List of Tables in an Oracle Database

The command that you should use to list the tables in an Oracle database depends on what information you're looking to isolate.

To list all the tables related the current user, enter
SELECT table_name FROM user_tables; 
.

To list the tables accessible by the user, key in
SELECT table_name FROM all_tables; 
.

To list all of the tables (ADMIN), enter
SELECT table_name FROM dba_tables;
.

Image: © Deymos.HR - Shutterstock.com
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team

Published by . Latest update on by Olivia Long.

This document, titled "How To List the Tables in an Oracle Database," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).

0 Comments