GeekArticles
FAQ
Oracle FAQ
FAQ
Oracle FAQOrder by dbms_random.value
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 -...
Sponsored Links
Read Next: Learning process
Related Topics
Subscribe via RSS
Oracle FAQ
- Synchronize data from remote location
- Oracle Fundamentals
- How to connect SQLPlus without tnsnames.ora
- Best Practices for App Server Keep Alive
- bind variables in triggers
- how to avoid outer joins
- One 900 column table versus ten 90 column tables.
- Does select generate undo ?
- Performance Question
- Help analyze statspack report
