PDA

View Full Version : Inserting records into Oracle utilizing Oracle functions for some fields



kettle_anonymous
04-25-2006, 11:12 AM
Is it possible to insert values as oracle functions? Some examples are:


sysdate
nvl
substr
something user defined



I thought about using javascript to concatenate a statement together but I think the insert action would actually enclose the result in quotes, which would defeat the purpose.






Any ideas?






Thanks,



John

MattCasters
04-25-2006, 02:09 PM
>I thought about using javascript to concatenate a statement together
>but I think the insert action would actually enclose the result in quotes, which would defeat the purpose.

It would do what? :-)

Anyway, you can use the "Call DB Procedure" step: simply specify SYSDATE as function and the name of the return value. (SystemDate or something)

It's as simple as that.

Please note that you can also obtain Sysdate from "Get System Info" and NVL is in Calculator.

HTH,

Matt