Is there any PL/SQL to display the list of all existing tables in a DB? SELECT TABLE_NAME FROM USER_TABLES will provide you with listing of tables in a particular schema. SELECT TABLE_NAME, OWNER FROM ...
Chapter 2, How to use Oracle SQL Developer and other tools This chapter from Murach's Oracle SQL and PL/SQL explains how to work with Oracle SQL Developer and other tools. In this section, learn how ...