Comments by Member 13329050 (Top 1 by date)

Hi, it helped me plenty. Coz when i didnt use "from tablename" it didnt work at all. And when I used "from tablename" it tried to insert it for each record in that table, that is why it always failed due to unique constraint on thet column.
When I used "from dual", it worked perfectly. Thanks.