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
- 6885 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 differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
What is vector point function?
What are different functions in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
what is transaction? : Sql dba
Why trigger is used in sql?
If i insert record in table A and these record should update in table B by using Trigger.How to achieve this.
Write an sql query to select all records from the table?
What are the advantages of sql?
How do I start sql from command line?
What is the difference between joins?
Why stored procedure is better than query?
-
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)
