I have a table called "X" (Master data table), based upon some condition i'l upload another table called "Y" (Child table) with the data (selected columns only) from table "X".
I would like to select once row from table "X" randomly and update table "Y". I'l do this for N no of times, all the time i should select unique data from table "X".
I request you all, pl help me with sample script.
Thanks & Regards,