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
- 6800 Views
- I also Faced
- E-Mail Answers
Answer Posted / kavitha
select table_name,num_rows from user_tables
where num_rows = 0
| Is This Answer Correct ? | 24 Yes | 4 No |
Post New Answer View All Answers
What language is oracle sql developer?
What is trigger point?
What do you mean by dbms? What are its different types?
What are the ways on commenting in a pl/sql code?
What are the dml statements?
what are the features and advantages of object-oriented programming? : Sql dba
How many columns should be in an index?
How do you use a while loop in pl sql?
What is the difference between a primary key and a clustered index?
Which table is left in left join?
What is offset and limit in sql?
What are records give examples?
How to write a query to show the details of a student from students table whose
What is sql prepared statement?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
