1. Display the post code and the purchase order number for each purchase order.

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

Question Posted / balu_deepak10

1 Answers
4350 Views
Wipro, I also Faced
E-Mail Answers

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

Answer / sarath

Select PO,POSTCODE from <TN>
Order by POSTCODE

Is This Answer Correct ?

2 Yes

1 No

Post New Answer

More Oracle General Interview Questions

What is Database Link ?

2 Answers

I have table-A(1,2,3)& table-B(3,4,5).what is the different b/w below questions? A union all B? B union all A?

2 Answers Zensar,

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers IBM,

i can't insert column value greater than 4000 characters at one instance even i am using CLOB datatype . how to insert efficiently more than 4000 characters ? And please let me know how to impose inline and out-of line constraints on oracle column??? Thanks in Advance... Prakash

2 Answers

How to call a stored procedure inside a trigger? Give an example.

1 Answers Exilant,

How to end the current transaction in oracle?

0 Answers

How to insert a new row into a table in oracle?

0 Answers

What is oracle latest version?

0 Answers

Explain the difference between sql and oracle?

0 Answers

How to drop a tablespace?