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
What are temporal data types in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What is the purpose of save points in oracle database?
How to define default values for formal parameters?
What is the recommended interval at which to run statspack snapshots, and why?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Explain alias?
How to shutdown your 10g xe server?
How to sort output in descending order in oracle?
Design database draw er diagram for a certain scenario ?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is primefaces used for?
How to import one table back from a dump file?
What are the database administrators utilities available?
Name the various constraints used in oracle?