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
4003 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

am completed mca2011 how get certification in oracle

1 Answers

1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records

1 Answers

hai, when to use char and varchar2....?

2 Answers

What are the predefined tablespaces in a database?

0 Answers

Describe the different type of Integrity Constraints supported by ORACLE ?

2 Answers

query to find the maximum no persons with same age(age colomn) from emp table

1 Answers

Why do we use coalesce function in oracle?

0 Answers

How many memory layers are in the shared pool?

1 Answers

What is define in oracle?

0 Answers

How to retrieve 5th highest sal from emp table?

8 Answers

what are the diffeenes between oracle 9i,oracle 10g

2 Answers

How to run the anonymous block again?

0 Answers

For more Oracle General Interview Questions Click Here