USER_TABLES

How to Resolve ORA-00942: table or view does not exist

by Ed Chen
March 23, 2019December 10, 2022
4 Comments

ORA-00942 ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist. The… Read More »

Scope of Views on DBA_TABLES, ALL_TABLES and USER_TABLES

How to List All Tables in Oracle

by Ed Chen
August 23, 2018December 10, 2022
2 Comments

In this post, we will talk about three different views that can make Oracle show tables within defined scope, they are: Tables that You Own… Read More »