1. Display the post code and the purchase order number for
each purchase order. Sort the output set by postcode.

Answer Posted / sarath

Select PO,POSTCODE from <TN>
Order by POSTCODE

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do you store pictures in a database?

563


How to do a full database export?

637


State and explain about oracle instance?

551


What does sharding mean?

539


I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

1976






Difference between varchar and varchar2 data types?

668


What is the recommended interval at which to run statspack snapshots, and why?

2437


How to define an anonymous block?

618


Why do you use stored procedures and state some of its disadvantages?

565


How to get maxsal , minsal, ename department wise in single query

1022


What is an oracle wallet?

515


Give the different types of rollback segments.

581


How to check database size in Oracle?

644


How to connect ms access to oracle servers?

552


What are the different editions of oracle?

591