Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To List All Tables in Your Schema
How To List All Tables in Your Schema? - Oracle DBA FAQ - Managing Oracle Database Tables
✍: 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.
2007-05-04, 4874👍, 0💬
Popular Posts:
What is NullPointerException and how to handle it? When an object is not initialized, the default va...
How do I debug thread ? This window is only seen when the program is running in debug mode. In windo...
How do you handle change request? Normally change request are handled by preparing an Impact analysi...
What is the difference between "calloc(...)" and "malloc(...)"? 1. calloc(...) allocates a block of ...
Can each Java object keep track of all the threads that want to exclusively access to it?