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 / eshwar
count(*) give the column count including null vaues
count(1),count(0) both will give the same result they will
count with out nulls
| Is This Answer Correct ? | 8 Yes | 8 No |
Post New Answer View All Answers
What is oracle soa suite?
testing tools?
can we get profile values in report without using user exists is it possible how?
Plz anybody send me Technical specification for AP Interface
How is choreography different from orchestration?
How to move the one file from one instance to another instance? And your scripts also?
is it possible to run the interface without using oracle apps?
what are the balancing segments in AR?
What is count(*) from po_vendors(any table)?
what is the difference between request group and request security in oracle apps?
Tell me how to debug the report?
What is a flexfield? List out its types.
How many schemas we have? how many you have used?
What is instead of trigger in where we will use?
Do you know what is applysys in oracle application database schema, what is apps?