Q
Problem solve Get help with specific problems with your technologies, process and projects.

Sorting rows randomly

In PL/SQL I have created a table with random numbers generated from the DBMS_RANDOM routine. Now I need to sort the rows and place them into another table, so that when the user extracts 'X' amount of records, they will get a true random sampling, and not just the ones at the top of the feed chain. What is the best way to sort, as I am putting records into another table?

I think best way to do it is to add a sequencing column S to the original table that will number the random numbers from 1 to N rows. When inserting to the new table, use X select statement that "chooses" random numbers between 1 AND N. Do X times:

INSERT INTO NEW_table ......
SELECT .... from OLD_TABLES
WHERE S = random_nbr (from 1 to N)

For More Information


Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close