1. Display the post code and the purchase order number for each purchase order.

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

Question Posted / balu_deepak10

1 Answers
4313 Views
Wipro, I also Faced
E-Mail Answers

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

Answer / sarath

Select PO,POSTCODE from <TN>
Order by POSTCODE

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More Oracle General Interview Questions

What is an Extent ?

3 Answers

How to recover a dropped table in oracle?

0 Answers

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers Mind Tree,

Oracle

0 Answers ABC, Genpact, HUI, Oracle,

How to loop through a cursor variable?

0 Answers

3. Display all the client numbers in the ORDER table. Remove duplicates.

1 Answers Wipro,

Whats the benefit of dbms_stats over analyze?

0 Answers

How do you find current date and time in oracle?

0 Answers

How to save query output to a local file?