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
Tell me how to find the custom directory in front end?
What is count(*) from po_vendors(any table)?
Do you know what is applysys in oracle application database schema, what is apps?
Tell me where we find the status of order information?
testing tools?
can we use look up type instead of a pofile option?or valueset?is it possible how?
What is oracle soa suite?
What is sca and how is it useful?
Can you differentiate between mediator and osb?
Hi any one plz help me .i need 2 or 3 customized and 2 or 3 development reports on PO module..if any body having plz send me with one by one step ,i mean where u do the customization and wht are the steps u follwed when u do the customization,wht are fields u added or deleted ,How u added or these fields as per clinet requirement and wht are errors u faced .plz send it to my mail id iamvenki@gmail.com
Can you explain the difference between architecture followed in 10g & 11g?
Are you familiar with internet architecture of oracle apps 11i?
Can we create tables in apps schema?
How can a process be deployed in soa?
Tell me how to debug the report?