Change style:

Big /
Small

Posted By

geekzspot on 12/01/12

Tagged

Versions (?)

Oracle Random Data

/ Published in: SQL

Randomly produce data every so often - good for generating test data ;)

Expand | Embed | Plain Text

SELECT DECODE(MOD(DBMS_RANDOM.RANDOM,3),0,SYSDATE,NULL) FROM DUAL; -- Randomly produce a date approximately every 1 in 3 times.

Report this snippet Tweet

Comment:

You need to login to post a comment.