Reload problem. Where Clause causing field to go null

[Anonymous]

I am loading the inventory history transaction table from IFS (PL/SQL) using the following script:

select

     transaction_code,

     date_created,

     cost

from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB;

this loads the whole table which is massive so I have been trying to restrict it to one year:

select

     transaction_code,

     date_created,

     cost

from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB

where TO_CHAR(DATE_CREATED,'YYYY') = '2018';

this works except the cost field shows only null values.

Has anyone else encountered this problem?

[wdchristensen]

If you pull the data for a different year is it populated? Is so, maybe the cost field has not been populated yet for 2018.

[shiveshsingh]

What's the o/p in sql developer? Are you getting values?

select

     transaction_code,

     date_created,

     cost

from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB

where TO_CHAR(DATE_CREATED,'YYYY') = '2018';

[sunny_talwar]

May be try this

SELECT

     transaction_code,

     date_created,

     cost,

     TO_CHAR(DATE_CREATED,'YYYY') year

from IFSAPP.INVENTORY_TRANSACTION_HIST_TAB;

Do you see year 2018 and in those rows does cost have any value?