what is count(*) from po_vendors(any table)? what does it do
and
what is count(1) from po_vendors(any table)?
what is count(0) from po_vendors(any table)
the out put is same
what is the difference
Answer Posted / bujji
select count(*) from temp1;
select count(1) from temp1;
select count(0) from temp1;
Above all 3 statements gives count (all are same) including
null vaues.
select count(Column_Name) from temp1;
Above statement gives the coulumn count witout null vaues.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
testing tools?
tell my any difficult situtation you solved in your experience in your company?
What is oracle soa suite?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Tell me where we find the status of order information?
Are you familiar with internet architecture of oracle apps 11i?
In oracle application how do you debug or trace errors?
Pls tel me the best text book for Oracle Apps 11i Tech? & I want D2K Text book also?
How to move the one file from one instance to another instance? And your scripts also?
please send me forms, xml pulisher questions,answers
What are the Standard Reports and Forms in HRMS?
CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP
Do you know what are user profiles in apps. Any examples you can give?
What is a flexfield? List out its types.