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 do you mean by merge in oracle and how can we merge two tables?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to view the data files in the current database?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What is save point in oracle database?
Why do we use coalesce function in oracle?
What are the different types of trigger and explain its various uses and functions?
What are the various oracle database objects?
What is index in Oracle?
How to delete all rows a table in oracle?
How to loop through data rows in the implicit cursor?
What is meant by joins?
How to get execution statistics reports on query statements?
What is oracle server autotrace in oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?