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
- 6819 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 |
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
what is not null constraint? : Sql dba
What is pl sql quora?
How do I know if I have sql express or standard?
what are different types of keys in sql?
How many commands are there in sql?
What is a sql driver?
What mean sql?
Does oracle roll back the transaction on an error?
How to handle bulk data?
Should I use mbr or gpt?
What does data normalization mean?
-
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)
