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 are the prerequisite set ups for inter organization transaction?

1 Answers   Scan Steel,

---

do you know is it possible to run the interface without using oracle apps?

0 Answers  

---

What is the reason for distribution hold. Why invoices will go on distribution variance hold ??

1 Answers   Oracle,

---

Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,

---

There are set of records to be processed from staging table into interface table. If one record fails the entire set of data should be rejected.

3 Answers   Satyam,

---

suppose you want to use a trigger in existing standard apps form and its not available in personalization neither in custom.pll. How you will address the issue ?

3 Answers   Oracle,

---

what is the use of anchors?

2 Answers   IBM,

---

If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?

0 Answers  

---

hi gurus my name is ramesh i was completed orcale apps technical trainning i wnt to put 3+yrs experience is it correct r not ,if any freshers jobs are available in market pls suggest me. my mail id rameshmcaou@gmail.com and contact no is 9000342411

3 Answers   Oracle,

---

Tell me how to find the custom directory in front end?

0 Answers  

---

what is instead of trigger. what is the use of that?

3 Answers  

---

How to write the no data found in XML Publiser Report in apps?

2 Answers   UST,

---