SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

insert data in interface tables

User_FZ3ZWOct 8 2015 — edited Oct 8 2015

Hi,

I have 4 interface table in which data comes from third party application to my application interface tables and then insert in my base tables on nightly batch.

now business want to move some data to third party application from my application on daily basis.

my requirement is:

can i use same interface tables to move data and then tell third party vendor to prepare query to take data from these tables.

i should prepare four different tables and then tell third party vendor to take data.

columns in both cases are same.

your suggestion is highly appricated.

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 5 2015

Added on Oct 8 2015

2 comments

484 views