sql query to get zero records from a table
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vipul.solanki
select * from menu_master where rownum <1;
Is This Answer Correct ? | 1 Yes | 2 No |
Explain oracle instance.
Explain what does a control file contain?
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the output of select * from emp where null=null & select * from emp where 1=1
How you find out version of installed workflow?
What is a static data dictionary in oracle?
What privilege is needed for a user to create indexes in oracle?
What is a directory object?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
What is a proxy class?
How to use "startup" command to start default instance?
How many categories of data types?