Collections:
Show All Tables in Your Schema in Oracle
How To List All Tables in Your Schema in Oracle?
✍: FYIcenter.com
If you log in with your Oracle account, and you want to get a list of all tables in your schema, you can get it through the USER_TABLES view with a SELECT statement, as shown in the following SQL script:
SQL> connect HR/fyicenter Connected. SQL> SELECT table_name, status, num_rows FROM USER_TABLES; TABLE_NAME STATUS NUM_ROWS ------------------------------ -------- ---------- REGIONS VALID 4 LOCATIONS VALID 23 DEPARTMENTS VALID 27 JOBS VALID 19 EMPLOYEES VALID 107 JOB_HISTORY VALID 10 COUNTRIES VALID 25 7 rows selected.
⇒ Managing Oracle Table Indexes
⇐ Turn On and Off Recycle Bin for the Session in Oracle
2019-05-10, 1650🔥, 0💬
Popular Posts:
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...