Answer Posted / nanne
Your Question is not clear..i believe that your expecting retrieve the tables which are having zero rows in the database.
Yes...we can retrieve the zero rows tables from DB
Select * from dba_tables
where num_rows = 0;
Regards,
Nanne
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by merge in oracle and how can you merge two tables?
How to write a left outer join with the where clause in oracle?
What is truncate oracle?
What is a named program unit?
Give the different types of rollback segments.
Is there any function in oracle similar like group_concat of mysql?
please explain.. DB architecture ...
Is there an oracle sql query that aggregates multiple rows into one row?
is there a tool to trace queries, like profiler for sql server?
What happens if variable names collide with table/column names?
What are the database administrators utilities available?
What is oracle rownum?
What is an oracle transaction?
What is PL/SQL ?
What are the oracle built-in data types?
