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;

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';

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.

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

what is the difference between procedure and function

4 Answers  

---

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

---

wht is difference between is and as varibales,while declaring procedure which is better?

3 Answers   Wipro,

---

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

2 Answers   Zensar,

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

what type of testing u r doing?

2 Answers   Convergys,

---

Can function be overload?

4 Answers  

---

can u explain which situation automonus transaction is used

2 Answers  

---

what is multi org structure?

3 Answers   Covansys, TCS,

---

Steps for DFF registration

2 Answers   IBM, Savvis, Wipro,

---

How can we import the data into a database using sql * loader?

0 Answers  

---

in one report using two layout models.if yes how to do

4 Answers   Covansys,

---