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
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