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
How to use "startup" command to start default instance?
How to define a specific record type?
How to create an oracle testing table?
How to retrieve data from an cursor to a record?
How to estimate disk space needed for an export job?
How do I call oracle stored procedures that take no parameters?
List the parts of a database trigger.
Is there any function in oracle similar like group_concat of mysql?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Explain oracle’s server parameter file.
How to do clean up if create database failed?
What are the various types of snapshots ?
Why do you use stored procedures and state some of its disadvantages?
Can sub procedure/function be called recursively?
What is a read write transaction in oracle?