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

Home -> Community -> Usenet -> c.d.o.server -> How: can I select a single random row

How: can I select a single random row

From: Baba Yetunde <nospam_at_nospam.com>
Date: Mon, 30 Apr 2001 22:04:23 GMT
Message-ID: <HjlH6.15966$Mz.2205031@news1.cableinet.net> 






Hi,



I have a table that has a field for Question and a field for Answer. How can
I run a procedure to select one row of questions and answers. I have 100
Q&A's. I am using Oracle 8.0.6 on AIX, I have tried using the
dbms_random.random package, but gives an error message " Function can not
guarantee Not to update database"




Any help req.



Fogun
Received on Mon Apr 30 2001 - 17:04:23 CDT












Original text of this message













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