Data Generator. Put value from VARCHAR to NUMBER collumn

[CrowKiller]

Hello. I need to setup NUMBER(19,0) not null collumn like FK of other table with VARCHAR column (it may contains XNA, or to_char of number value)

I cant to use FK generator because types are different

I have tried to use this query result

Code: Select all

SELECT cast(to_number(code_employee) sa NUMBER(19,0)) from owner_dwh.dct_employee 
where code_employee<>'XNA' and code_employee is not null

But i have the allert "source collumn allows nulls"

If i tried to insert in nullable collumn query result is empty (but same command works well in developer and return not empty result). If I use to_number - result is always empty. whats wrong?

screenshot : https://yadi.sk/i/9HNzUOB9jcU8Kw

[alexa]

We will investigate this issue and will answer you as soon as possible.