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

What is the maximum number of triggers that can be applied to a single table?

What is the scope of a local variable?

What is a data segment ?

Will you be able to store pictures in the database?

How to check the oracle tns settings?

what is query and types of query

What is the use of Control File ?

why pl sql doesn't support retrieving multiple records

Can a property clause itself be based on a property clause ?

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

what is the difference between UNION AND UNIONALL

How do we represent comments in oracle?

For more Oracle General Interview Questions Click Here