I recently started playing in Oracle Live SQL (https://livesql.oracle.com/ ) just to see what its all about.
I think its an excellent tool for folks to just be able to login and kick around some SQL to play with, which was what I was exactly doing.
I noticed though, that ROLLBACK does not seem to work?
I was even trying to follow a tutorial for ROLLBACK here: https://livesql.oracle.com/apex/livesql/file/content_GZVG5BBC5JMEIFPVA75UFPFDM.html
I executed the script up to step 5 and I am still getting data - Though I would expect, as per the script stated and from personal knowledge that the data should be gone since I rolled back.
I was wondering, has anyone tried using ROLLBACK in Oracle Live SQL and have it work for them?
Am I missing a setting some where?
I have a gut feeling that AUTOCOMMIT may be on for every transaction, as thats the only other thing I can think of.
I tried to explicitly run SET AUTOCOMMIT OFF - But it said that its an unrecognized command.