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
- 6918 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 scope and visibility in PL/SQL?
What is identity column in sql server?
What does the file extension accdb stand for?
What is sorting in sql?
What is asqueryable?
What is execute immediate?
How can I tell if sql is running?
Is a secondary key the same as a foreign key?
What is the use of prepared statement?
what is julian date in oracle
Explain the difference between triggers and constraints?
What are functions in sql?
-
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)
