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 workflow?Explain with a example?

2 Answers   Oracle,

---

how to use .prt file in bitmap reports?

2 Answers   Accenture,

---

Difference between triggers and procedures?

2 Answers  

---

What is the difference between base table and multi-org table?

3 Answers   Infosys,

---

How can u find custom top? where its located? How to find custom top in front end?

1 Answers  

---

What is the interface?

3 Answers  

---

What do you understand by concurrent programs?

0 Answers  

---

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

1 Answers   BirlaSoft,

---

what is the difference between %_all and %_f tables

1 Answers  

---

tell me the scenarios of between pages in reports

1 Answers   TCS, Wipro,

---

can we write sql statement in Format trigger?

4 Answers  

---

Who information?s?

2 Answers  

---