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
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 |
Oder of firing triggers in form
1) why we need to do Validations when the Standard Conc. Prog or the API will do all the validations 2) How can we display more then 1 column data in a formula column (Ex displaying Empno, Ename, sal data in one Formula column) 3) is it possible to give 2 out paramaters in a function
we have 4 managers if one person logon the system automatically displays his siganature and name how?
Form development process?
what do u mean by debit/credit memo invoices?
3 Answers ACC, Convergys, Mascon,
how to find the custom directory in front end.
1 Answers IBM, Sierra Atlantica,
how to get the on hand quantity of an item across all organizations? name the underlying tables.
2 Answers Ranves IT Solutions, Scan Steel,
is UOM maintained at master level or organization level or both?
How do u customize the Reports?
Tell me how to find the custom directory in front end?
What are do's and dont's of Interface?
How can u populate data into po_headers_all segment2 column?