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!

truncate table while accesing multiple users

852469Jun 14 2013 — edited Jun 14 2013

suppose i have written "execute immediate truncate table TEMP" within procedure

then insert....into temp values(.....select .....);

if multiple users want to execute the procedure will it impact on the result set?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 12 2013
Added on Jun 14 2013
8 comments
494 views