<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I am wondering if the use of :<br />
order by <br />
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; dbms_random.value <br />
<br />
in an Oracle query with outobs = 10 in the Proc Sql statement could cause records that are in the table not to be be selected.<br />
I am trying to select 10 records that have a certain status code. &nbsp;I wanted to randomly pick the records and limit the number of records.<br />
<br />
If there are only 30 records on the table that meet the criteria, it is possible that all of the 30 records are being bypassed because of the randomizing routine causing me to get no records in my selection?
</div>
</div>


Experts,

I am wondering if the use of :
order by 
	     dbms_random.value 

in an Oracle query with outobs = 10 in the Proc Sql statement could cause records that are in the table not to be be selected.
I am trying to select 10 records that have a certain status code.  I wanted to randomly pick the records and limit the number of records.

If there are only 30 records on the table that meet the criteria, it is possible that all of the 30 records are being bypassed because of the randomizing routine causing me to get no records in my selection?

Randomizing in Oracle with limited outobs

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.