none
Oracle Select Query in ADF

    Question

  • Hi Team,

    We are trying to execute the "select * from tablename1,tablename2 where tablename1.id=tablename2.id" using Oracle Database connector. But while working on Oracle connector we don't see option to write query like SQL source connector instead we have only Table name selection option.

    Could you please help on this, we are stuck with select query for Oracle Connector instead of selecting single Table option.

    Monday, August 20, 2018 9:10 AM

Answers

  • Hi,

    If you want to use query in oracle, you need to reference the oracle dataset into an activity, for example, in lookup activity:

    or in copy activity:

    Hope it'll help. Thanks.

    Monday, August 20, 2018 9:46 AM

All replies