Data Generator. Put value from VARCHAR to NUMBER collumn

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
CrowKiller
Posts: 1
Joined: Tue 26 Mar 2019 11:11

Data Generator. Put value from VARCHAR to NUMBER collumn

Post by CrowKiller » 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

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
Devart Team
Posts: 2856
Joined: Fri 24 Jun 2011 14:17

Re: Data Generator. Put value from VARCHAR to NUMBER collumn

Post by alexa » Wed 27 Mar 2019 16:27

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

Post Reply