Skip to Main Content

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!

How to deal with 'intermediate table'

3703006Jun 28 2018 — edited Jun 29 2018

Dear experts,

eg: I have an original table with all the source data. While through multi process (fetch source data to an temporary table A,  calculate table A and save the result in another temporary table B, then save it to another table), how to deal with these intermediate tables / views..etc?  I mean, you create them separately or you create them in your running procedure using ''execute immediate''.  I admit it's not a good way using execute immediate, but sometimes you have a 'proper' DB, I don't want to add some extra intermediate table to bother other guys considering them just inter stuff with no other uses, so I create it in the procedure and drop it at the end, while it's time wasting and with other inconvenience too.

Anyway, how can I deal with this intermediate things?

Best regards,

cc

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 27 2018
Added on Jun 28 2018
6 comments
615 views