RE: Can't figure out the SQL syntax for this.Does anyone know?

[Gustavo Henrique Sberze Ribas]

> information I want randomly but I can only figure out how to 
> get one record. Anyone have any ideas?

  What about using 'rownum <= [number_of_desired_records]' ?
 
 (SELECT card_number, promo_id FROM cell_card
   where cell_id = 246 ORDER BY dbms_random.value )
 WHERE rownum <= 10;


--
Gustavo