apply interval day to second function to character data

[mahajanakhil198]

Did you try this in your control file?:

LOAD DATA 
... etc ...
my_interval "TO_DSINTERVAL(:my_interval)",
... etc ...

Thanks. Actually I could find that after searching for 2-3 hours, I almost forgot that such a function exists.