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
- 4 Answers
- 10598 Views
- IBM, I also Faced
- E-Mail Answers
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
Suppose for report I have to parameters those are from_date and to_date, so to_date should be greater when compare to from_date, if we are giving to_date is lessthen it must shows some error how we will make?
what is pay run id ?
Tell me how to debug the report?
Tell me how to find the custom directory in front end?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?
pls send me out bound code of supplers,site,bankiformation code pls as soon as
Can you define an erp system?
How many schemas we have? how many you have used?
How can a process be deployed in soa?
Can we create tables in apps schema?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
Can you differentiate between mediator and osb?
q)what are the validations in sql*loader
Do you know where we can check the status of po?
What is sca and how is it useful?
