Answer Posted / sts

Select Deptno,Count(*) from Emp Group By Deptno having Count(*)=(SELECT max (count(*)) FROM EMP GROUP BY DEPTNO);

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

1114

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2200

---

What is difference between sid and service name in oracle?

1018

---

material view and view disadvantages?

1127

---

What is the difference between primary key and unique key and foreign key in oracle?

1037

---

How to view all columns in an existing table?

984

---

How to use "if" statements on multiple conditions?

1217

---

What is a tns service name?

1058

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1924

---

What is object data modeling?

1017

---

what is port in oracle? how is it related to database application.

1992

---

How to define an anonymous block?

1247

---

Respected sir, Please send me technical questions related to oracle apps..

1868

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3386

---

What do you understand by database schema and what does it hold?

1301

---