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

Answers were Sorted based on User's Feedback



what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(..

Answer / sandeep sutar

Result if count(*), count(1), count(0) will be same.

Howevenr,

When we use count(*) then
first oracle query executer gets all the rows in buffure
cache, including all column and then counts all the rows.
this will impact with less performance.


select count(1) or count(0)
This reduces unwanted I/O by selecting just '1' against all
the rows.


Best practice to getting rowcount of table is

select count(rowid) from table_name;

Is This Answer Correct ?    10 Yes 1 No

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(..

Answer / koti

Not For above Qution..........

Q)How to fine How many coloumns in the APPs TABLES ?

Ans):-

select count(*) from dba_tab_columns
where table_name ='give apps table name';

Is This Answer Correct ?    4 Yes 0 No

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(..

Answer / 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

what is count(*) from po_vendors(any table)? what does it do and what is count(1) from po_vendors(..

Answer / 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

More Oracle Apps Technical Interview Questions

what are the mandatory parameters in suppler Conversion?

1 Answers   Tech Mahindra,


HOW CAN U KNOW THE STAUS OF PO?

1 Answers   TCS,


Explain what are the tables of auto invoice?

0 Answers  


explain o2c cycle? what are the table reflected for this process?

1 Answers   BirlaSoft,


what is the difference between request group and request security in oracle apps?

1 Answers  






what is the database size you used?

1 Answers   FIS,


where is setup of business group done?

2 Answers   TCS,


How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers   KPIT,


How to find which company will be conducted Oracle appa interview? Plz help me

3 Answers  


what are the difference between 11.5.7 and 11.5.9 in oracle apps

4 Answers  


Explain oracle apps architecture.

0 Answers  


You are working with interfaces if client doesnot give any flat then what will u do?

8 Answers   Wipro,


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)