Interested to Buy Any Domain ? << Click Here >> for more details...
If 100 tables are there in user_tables.I want to find in which
table zero records are there with table name.Is it possible?
- 2 Answers
- 6799 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kavitha
select table_name,num_rows from user_tables
where num_rows = 0
| Is This Answer Correct ? | 24 Yes | 4 No |
Answer / arpan
Use the column "blocks" from the view user_tables. eg:
select * from user_tables u where u.blocks = 0;
| Is This Answer Correct ? | 5 Yes | 6 No |
What is the location of pre_defined_functions.
What is update query?
What is coalesce in sql?
How do I find sql profiler?
Describe different types of general function used in sql?
What are the two types of cursors in pl sql?
What does subquery mean in sql?
Why does %isopen return false for an implicit cursor?
what the meaning of sql
Why query optimization is needed?
What is the difference between nvl function, ifnull function, and isnull function?
What is a crud api?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
