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 DTS and purpose of DTS ?

What is an oracle wallet?

How will you identify oracle database software release?

How to add a new column to an existing table with a default value?

Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??

How to grant create session privilege to a user in oracle?

why should i declare foreign key constraint as self relation instead of binary relation in tables ?

Can you assign multiple query result rows to a variable?

What privilege is needed for a user to query tables in another schema?

What are advantages fo Stored Procedures?

11. Display the client number and name and the client number and name of the person who referred that client.

I have a database backup file in .db (ext) form how to conver it into .dmp (ext.) for oracle database

For more Oracle General Interview Questions Click Here