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