Small questions on Data Generator

Maxmix

Member³
1) Cannot find out how to generate dates with time portion?

2) Connected as UserA, I am Adding Existing Table from schema UserB, and then
the name of chosen table goes into Table combobox, but Owner combobox remains blank
 
1) Cannot find out how to generate dates with time portion?
You can use an SQL expression for this. For example:

SQL(trunc(sysdate) + dbms_random.value * 10)

This generates dates up to 10 dates in the future, including a time fraction.

2) Connected as UserA, I am Adding Existing Table from schema UserB, and then
the name of chosen table goes into Table combobox, but Owner combobox remains blank
Indeed. We'll fix it.
 
Marco Kalter said:
1) Cannot find out how to generate dates with time portion?
You can use an SQL expression for this. For example:

SQL(trunc(sysdate) + dbms_random.value * 10)

This generates dates up to 10 dates in the future, including a time fraction.

Thank you!
 
Back
Top