Tech Tutorials Database
GeekArticles FAQ Oracle FAQ
 

Order by dbms_random.value

 
Author: asktom.oracle.com
Category: Oracle FAQ
Comments (0)

Hi tom, To display the random order of rows every time , I give SQL> select object_id from user_objects order by dbms_random.value It displays what I wanted. but if I give SQL> select object_id from user_objects order by .88439942 -...

Read More...




Sponsored Links




Read Next: Learning process



 

 

Comments



Post Your Comment:

Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe