Answer / nilam

SQL aggregate functions return a single value, calculated from values in a column.




Useful aggregate functions:




AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum

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.

0 Answers  

---

Hi All, Recently I attended a interview for a developer position in an educational university. They asked me the a question, I answered somehow but I was not not satisfied myself. Can anybody reply for it? The question is: A business user comes to you directly with an urgent request:: there is a problem with some students not being able to re-enrol. It appears that ?something has gone wrong with the end-dating of some previous courses they had enrolled in, and this is preventing them from completing their on-line re-enrolments?. Fortunately the user has done some analysis on the situation, and has developed some code to change the end dates. They tell you that they have tested this code in the ?dev? environment, and it works fine. They are asking you to please get this implemented in production as soon as possible. What steps would you take in response to their request ? Thanks

2 Answers  

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

0 Answers   Oracle,

---

What is Oracle table?

1 Answers  

---

What is cursor

4 Answers   TCS,

---

What is a private synonym?

0 Answers  

---

What is Data Block ?

2 Answers  

---

Why do you use stored procedures and state some of its disadvantages?

0 Answers  

---

What are the differences between a sys and system user and what are the extra privileges available to the sys user?

1 Answers   Wipro,

---

What is SAVE POINT ?

5 Answers  

---

pls explain connect by prior with example and its real time use

3 Answers  

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

0 Answers  

---