Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to use subqueries with the in operator using oracle?
How to connect to a local oracle 10g xe server?
How to delete an existing row from a table in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What privilege is needed for a user to create views in oracle?
What is tns service name?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What is oracle thin client?
What is a user account in oracle?
How does one get the view definition of fixed views/tables?
Does facebook use oracle?
What is the difference between I and G in Oracle?
what are bitmap indexes? How does they work?
How do we get field details of a table?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
