Interview Questions Answers in Oracle General

bala deepak gunji

{ City }
< Country > india
* Profession *
User No # 52331

Total Questions Posted # 5
Total Answers Posted # 0

Total Answers Posted for My Questions # 9
Total Views for My Questions # 21075

Users Marked my Answers as Correct # 0
Users Marked my Answers as Wrong # 0

Questions / { bala deepak gunji }

Questions Answers Category Views Company eMail

1. Display the post code and the purchase order number for each purchase order. Sort the output set by postcode.

Wipro,

1 Oracle General 4265

2. Display the post code and the total number of purchase orders placed with creditors in that post code.

Wipro,

Oracle General 2003

3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.

Wipro,

Oracle General 2159

4. Using a set operator, display the creditor number of all creditors who have ever been paid.

Wipro,

2 Oracle General 5000

5. Display full details for the creditor/s who has received the single largest payment. Do not use a table join or set operator anywhere in your query.

Wipro,

6 Oracle General 7648

Answers / { bala deepak gunji }