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, 1721🔥, 0💬
Popular Posts:
How To End a Stored Procedure Properly in SQL Server Transact-SQL? Where the end of the "CREATE PROC...
How To Generate CREATE TABLE Script on an Existing Table in SQL Server? If you want to know how an e...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...