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, 2082🔥, 0💬
Popular Posts:
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...