Read data from view in oracle DB

[Former Member]

Hi Experts,

There is requirement where instaed of reading data from an oracle db where the fields are placed in various tables...

Is it possible that I read it from a pre defined view in oracle?

I can execute the statement select * from view_name where PI_read= 'N' in the sql editor

Can I use the same in the JDBC sender channel config?

Awaitign ur replies..

Regards,

Teja

[MichalKrawczyk · Accepted solution]

Hi,

>>>Is it possible that I read it from a pre defined view in oracle?

yes - you can use views in sender jdbc adapter

Regards,

Michal Krawczyk

[baskar_gopalakrishnan2]

>>Is it possible that I read it from a pre defined view in oracle?

Yes, you can read from staging tables or regular db tables. No issue.

>>I can execute the statement select * from view_name where PI_read= 'N' in the sql editor

Use the SQL Query in the sender jdbc select field in the cc.

>>Can I use the same in the JDBC sender channel config?

Yes. same procedure. No changes.

[former_member181985]

Not sure if you can use View concept. But give a try. If it doesnt work, you can go ahead with stored procedure which can actually call the view.