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 6578

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

2248

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.

2170

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

2080

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 5533

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

2 5243

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

2 5535

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

5 8339

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

1 4433

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

2105

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

2262

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

2 5237

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 8123

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 3040

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 17478

Post New Wipro Oracle General Interview Questions

Wipro Oracle General Interview Questions

Wipro Oracle General Interview Questions (46)

Un-Answered Questions

Explain the function of trau?

1072

What is asp and jsp?

957

What is try catch in scala?

How much data can excel handle?

780

What is the best tool to develop Play/Scala applications to persist data in MongoDB NoSQL data store?

Is flexbox responsive?

644

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2344

Is truncate ddl or dml?

1038

What do you mean by source type in splunk?

223

Mention what are some bad examples of web design?

947

What are the LSI keywords?

611

Suppose if you decided to delegate what type of instructions would you give your staff?

1157

What is a constant and types of constants in c?

1176

What are strong primes and are they necessary for RSA ?

2063

Suppose you are heterozygous for a mutant beta-thalassemia allele. If the frequency of beta-thalassemia is 1/1600 persons, what is the probabilty that your prospective spouse is heterozygous for a mutant beta-thalassemia allele?

2134