I wrote a script to run with SQLPlus which deletes the previous seven days of data in my Oracle XE database. I logged into the database with SQLPlus, ran the script, and it showed me the correct rows had been deleted. I tried to query the same date range again just to make sure, and the query returned no results (i.e. the records were deleted).
However, when I then connect to the database using Oracle SQL Manager, I can go to the same table and all the data is still there! If I run the query in SQL Manager, it is then deleted from the table in SQL manager.
Anyone know why this is happening? The credentials I use to log in are the same in both instances and I’ve made sure to be logged out of SQL Manager when running SQLPlus and vice-versa. I’m running version 18c of XE database.