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 P2P cycle.

27 Answers   Accenture, Deloitte, EE Limited, EXL, IBM, Tech Mahindra,

---

why we can use synonym?

6 Answers  

---

What is multi org?

6 Answers   Accenture, CTS,

---

any one can expalin report registration steps?

6 Answers   Infosys,

---

What r the validation done in ap inbound ?

2 Answers   Questam,

---

---

how many sections are there in report?

1 Answers  

---

what is instead of trigger in where u will use?

2 Answers   TCS,

---

How can u call a standard interface program from sql or pl/sql code?

3 Answers   Satyam,

---

how to create a file in forms?

3 Answers   Wipro,

---

Please let me know the differance between Master Item and organization Item in Inventory.

5 Answers   Wipro,

---

what is MRC? Why it is needed?

4 Answers   Convergys,

---

What is GLOBAL TEMPORARY TABLE and It's significance ?

3 Answers   KPIT,

---