Select PO,POSTCODE from <TN> Order by POSTCODE

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

Question Posted / sarath

Answer Posted / sarath

Select PO,POSTCODE from <TN>
Order by POSTCODE

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is pragma autonomous transaction in oracle?

1039

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2278

what are bitmap indexes? How does they work?

2217

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1046

How do I recompile a procedure in oracle?

947

How would you change old and new values in an insert, delete and update triggers?

995

How to call a sub procedure?

1072

What is index-organized table in Oracle?

1052

Can we insert data in view oracle?

996

Is there an oracle sql query that aggregates multiple rows into one row?

961

How do I call oracle stored procedures that take no parameters?

1083

How to define a data field as not null?

1091

What happens to the indexes if a table is recovered?

971

What is an index associated with a constraint?

1016

What is recycle bin in Oracle?

1130