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 the use of analyse option in exp command.
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
What do you mean by a deadlock?
Difference between the “verify” and “feedback” command?
How to drop an existing view in oracle?
How to connect to a local oracle 10g xe server?
what is port in oracle? how is it related to database application.
what are the default admin accounts in Oracle 10g ?
how to retrieve 1st and last row of table without using group functions??
How to get a list of all tables in the database?
dear sir/madam, i have done my engg in 2007 after that i did oracle course (sql,plsql,forms,reports) .from 2008 to 2009 i searched job but didnt got.so i planned to move to sales field & i gone to dubai.till now i m in sales only.now i want to shift my career in to IT industry.but now people are not hiring as fresher.so i planned put fake 1 + exp. is it good or bad or any other way is there to enter in IT.please suggest me or call me 09632087338.
What view(s) do you use to associate a users SQLPLUS session with his o/s process?