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 |
WHT ARE THE AGGREATE FUNCTIONS?
How to assign query results to variables?
how to truncate date and get only time part 9:20:00
Define Normalization with example?
How to empty your oracle recycle bin?
What is primefaces used for?
What is the quickest way to fetch the data from a table?
What is Rollback Segment ?
Explain view?
what is the scripts in data base?
how the indexes are stored in the Oracle Database?
Explain the use of grant option in exp command.