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 |
10. Display the client number, order date and shipping date for all orders where the shipping date is between three and six months after the order date.
What are the most common interview questions on ETL Testing for experience?
how to find find & delete duplicate rows from two different tables?
How to view all columns in an existing table?
What is the purpose of tables, private synonyms and public synonyms in Oracle?
Can a field be used in a report without it appearing in any data group ?
How can you merge two tables in oracle?
What is translate in oracle?
How to create a new view in oracle?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
3. Display all the client numbers in the ORDER table. Remove duplicates.
What is transaction control statement and how many types of transaction control statement in Oracle?