SELECT mobile, rid
FROM (SELECT mobile, ROWNUM AS rid
FROM mobile ) ttt
WHERE rid = (SELECT TRUNC (DBMS_RANDOM.VALUE (1, 100))
FROM DUAL);
FROM (SELECT mobile, ROWNUM AS rid
FROM mobile ) ttt
WHERE rid = (SELECT TRUNC (DBMS_RANDOM.VALUE (1, 100))
FROM DUAL);