Please Visit Our New Website for Further Communication

Amazon

28 Mar 2013

Getting Random Rows from Oracle Table Using DBMS_RANDOM

To fetch random rows from Oracle table use DBMS_RANDOM.

SELECT column FROM( SELECT column FROM table ORDER BY dbms_random.value ) WHERE rownum <= 10

2 comments:

  1. Hi neeraj
    I attended interview on mar 22nd. I cleared two rounds. In hr round the discussion gone through about salary and notice period and finally she told that wait for two weeks we will send status to your mail . But till now am not getting any mail.Its nearly one month completed. Please tell me that what its mean? Am i selected or not?
    Thank you

    ReplyDelete
  2. Hi Neeraj,

    i have 3+yrs experience in java... i cleared both technical and Hr rounds... Hr told me that i got selected.. now i want to know in how days infosys will release the offer letter ? please reply

    ReplyDelete