If I am using on database connection, but I am creating temporary table to store and organize the data into managable information. Will I lose my temporary table when I close() the cursor or should I should I use a for loop to execute my sql in one cursor????
Thank You
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If I am using on database connection, but I am creating temporary table to store and organize the data into managable information. Will I lose my temporary table when I close() the cursor or should I should I use a for loop to execute my sql in one cursor????
Thank You
Temporary tables go away when the connection goes away. The cursor doesn't matter.