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

More Oracle General Interview Questions

How to rename an existing table?

How to delete all rows a table in oracle?

what is cartesian product?

8. Display the client name and order date for all orders using the natural join keywords.

In what script is snap$ created? In what script is the scott/tiger schema created?

What WHERE CURRENT OF clause does in a cursor?

How do I spool in oracle?

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.

select * from emp what happened internally when we write this query in the sql prompt?

What exactly do quotation marks around the table name do?

What are the different types of databases?

Which Functions Using Integer ==> String's i.e 2 ==> Two... Like that string's ==> integer values ? It is Possible ?

For more Oracle General Interview Questions Click Here