Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category
Oracle General Interview Questions
Questions Answers Views Company eMail

16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string .

Wipro,

1 4069

17. Display the order number and average item cost for each order.

Wipro,

1 3935

18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client has placed orders to the value of

Wipro,

2 5606

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

Wipro,

2 6464

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

Wipro,

2187

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.

Wipro,

2108

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

Wipro,

2022

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.

Wipro,

3 5406

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

Wipro,

2 5155

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

Wipro,

2 5449

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

Wipro,

5 8152

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

Wipro,

1 4341

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

Wipro,

2065

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

Wipro,

2210

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

Wipro,

2 5140

Post New Oracle General Questions

Un-Answered Questions { Oracle General }

How to put more than 1000 values into an oracle in clause?

1029

can anyody please send me the dump for Oracle 10g certifications for DBA path?

2122

How do we get field detail of a table?

1080

How to increment dates by 1 in oracle?

1085

How to select some rows from a table in oracle?

1078

What is blob data type in oracle?

1123

How to assign a tablespace to a users in oracle?

1048

What is a trigger oracle?

1086

How do we display rows from the table without duplicates?

972

What is oracle database 10g express edition?

1118

What is an oracle table?

988

How to store pictures on to the database?

975

State some uses of redo log files?

1007

How will you identify oracle database software release?

1010

How much memory your 10g xe server is using?

1103

For More Un-Answered { Oracle General } Questions Click Here