Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12039 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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 |
in which table sub inventory related information for item is stored?
3 Answers chain sys, Scan Steel,
what is the difference between oracle 8i and 9i?
what are the functions you are used in utl_file at the time of transferring the data?
In which directory your flatfile is given?if u connected different instance where it is find?
How many standard interface programs in oracle purchasing module and oracle inventory? What are they?
Cycle of requestion to receving transaction.
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
what are the error tables in AP?
What are different execution methods of executabls?
How do u identity its name of report?
Except the SRS window in which we can submit the concurrent program.
how to set org context?
Oracle Apps Technical 
