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
4427 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 a cursor and what are the steps need to be taken?

0 Answers

What are the different pseudo commands? Explain in general?

0 Answers

which language is used to develop the oracle........?

4 Answers Infosys,

How to connect to a local oracle 10g xe server?

0 Answers

two tables are there emp(eno,ename,sal,deptno),dept(deptno,dname).how form the query in deptno,ename,max(sal)

2 Answers

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

0 Answers Oracle,

Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?

0 Answers

How to rename an index in oracle?

0 Answers

How to create a new view in oracle?

0 Answers

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

0 Answers iFlex,

Define Normalization with example?

1 Answers

How to run the anonymous block again?

0 Answers

For more Oracle General Interview Questions Click Here