Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Inserting records into Oracle utilizing Oracle functions for some fields

  1. #1
    Join Date
    Sep 2005
    Posts
    1,403

    Default Inserting records into Oracle utilizing Oracle functions for some fields

    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

  2. #2
    Join Date
    Nov 1999
    Posts
    9,729

    Default RE: Inserting records into Oracle utilizing Oracle functions for some fields

    >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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.