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 a database transaction & what all tcl statements are available in oracle?
Explain user account with reference to oracle.
What is the sql query to concatenate column values from multiple rows in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the limitations of check constraint?
What is the data pump import utility?
Explain a synonym?
What is transaction control statement and how many types of transaction control statement in Oracle?
How to insert a new row into a table in oracle?
How do I connect to oracle?
What do you mean by cdb and pdb in oracle 12c?
How to view the tablespaces in the current database?
What is hash cluster in oracle?
What are the differences between blob and clob in oracle?