Data Generator. Put value from VARCHAR to NUMBER collumn
Posted: Tue 26 Mar 2019 11:44
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
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
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 nullIf 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