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
- 6883 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
What is sql performance tuning?
What is pl sql and why it is used for?
What is sql comments?
Can we call dml statement in function?
Which command is used to delete a trigger?
Is oracel sql developer written in java?
What is primary key sql?
What are sql queries used for?
Does postgresql run on the cloud?
How do you run a query?
How to check if a column is nullable before setting to nullable?
What is view explain with example?
What are the datatypes available in pl/sql ?
What is delete command in sql?
