Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: To display 5 Largest values from table

Re: To display 5 Largest values from table

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 21 Mar 2003 17:03:02 +0100
Message-ID: <jsdm7vsraqisetjb8c8vo50l3t0hsn8qp3@4ax.com> 





On 21 Mar 2003 06:38:07 -0800, gforestieri9_at_yahoo.com (Greg
Forestieri) wrote:



>You might want to use dynamic sql as the users might

>want to vary the number.





Actually there is no reason why you can't put the limit in a bind
variable, so please don't recommend dynamic sql




Sybrand Bakker, Senior Oracle DBA



To reply remove -verwijderdit from my e-mail address
Received on Fri Mar 21 2003 - 10:03:02 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US