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, 1641🔥, 0💬
Popular Posts:
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...