Using Sample statement

[Mikerosoft]

Has anyone used the Sample statement in Oracle 8 successfully. I am trying to retrieve a random set of records from a table without success. Following is the code I'm testing with.

Select * from TWMWR SAMPLE (10)

and get a SQL command not properly ended error.

TIA,
Mike

 

[Advocate]

Mike, the only reference I can find to 'sample' is the Sample parameter of Analyse command which is used to return statistical info of an object and not data rows (pity - because I was hoping to learn a new trick)

Best of Irish Luck, David.
djwilkes@hotmail.com

 

[Mikerosoft]

David,
Thanks for responding. It seems this command is only available in 8i and not 8.05 which is what we are running. But it does return a random sample of records from a data set.

Best,
Mike