I am creating a global temporary table on commit delete rows and then do a select right after. The rows disappear from the global temporary table. I read that only a commit or end session delete the rows, but not in my case.
I looked up toad setting and found Auto Commit is unchecked under options->Oracle->Transactions. So, what am I missing. I also tried "set autocommit off" prior to the execute script and didn't work either. The status bar does not show auto commit either. Thanks for your help.