Help

[Sim]

Sorry my english is very terrible!! :-/<br>
<br>
I should write a package to sort numbers and data in Oracle with bubble sort and quick sort. SQL should show me the elapsed time. At the moment I have no clue how.<br>
<br>
Please help. <br>
<br>
Thanks very much!<br>
<br>
SiM

 

[MikeLacey]

SiM,<br>
<br>
Your English looks fine to me!<br>
<br>
Why do you want to write this yourself? It would be very simple to do this in three steps.<br>
<br>
1) Create temporary table that will hold your data<br>
2) Insert all your data into the table<br>
3) Use &quot;Select... Order By...&quot; to get a sorted list.<br>
<br>
Be Lazy. Be VERY Lazy.<br>
<br>
Mike<br>
<p>Mike Lacey<br><a href=mailto:Mike_Lacey@Cargill.Com>Mike_Lacey@Cargill.Com</a><br><a href=

http://www.cargill.com/>

Cargill's Corporate Web Site</a><br>