Hi Techies,

We can do it in this way also..

-- For getting four digit random number
SELECT FLOOR(1000+ RAND()*8999) FROM DUAL;

__________________
Keep smiling...