Wipro Oracle General Interview Questions Answers, Wipro Placement Papers, Wipro Technical, HR Interview Questions, Wipro Aptitude Test Questions, Wipro Campus Placements Exam Questions

Company Name Starts with ...

# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Wipro Oracle General Interview Questions

Questions Answers Views Company eMail

19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.

2 6476

20. Using a set operator, display the client number of all clients who have never placed an order.

2199

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2120

22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100

2025

23. Display the client name for all clients who have placed an order where any order line has more than 3 items. Do not use a table join anywhere in your query.

3 5427

24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.

2 5167

25. Display the client number and the value of the highest value order placed by that client.

2 5465

26. Display the earliest shipping date in the format: DD/MON/YYYY

5 8195

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

1 4354

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

2072

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

2224

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

2 5153

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.

6 7949

I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.

1 2989

write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.

11 17145

Post New Wipro Oracle General Interview Questions

Wipro Oracle General Interview Questions

Wipro Oracle General Interview Questions (46)

Un-Answered Questions

how we can find sieve #4 is 4.75mm?

2325

Pl's confirm me this entry how to pass in Tally 9.0 & Tally ERP.9 that if I purchase 20 mobile,30 phone,20 LCD,15 laptop from mangesh @ Rs.7000,Rs.200,Rs.17000 and Rs.14000 respectively on each. But I purchase by cash and 15 days later I sold half of the thing to priya margin of Rs.100 on each by cheque and rest i sold to minal on cash margin of Rs.200 on each. But I received cash 1 month later. so calculate how much profit I got by selling the products.

3315

What is the use of running the scripts in Hidden-mode in UFT?

1230

What is dequeue operation?

976

What are the common values used in 2d transforms?

584

What are the 3 different types of Groups?

907

What is collective processing of gl accounts? : fi- general ledger

1122

What causes an ociw32.dll error? : BEA Weblogic

1167

Describe the android application architecture.

938

Explain insurance project modules,and what we need to test on which functionality?

1103

Is there a way to break long lines in VB code?

1390

Explain pointers in c programming?

1124

Define static function?

1027

What can be the causes of fatty liver?

1082

What is object repository? How can we create object repository in selenium?

1068