Search code examples
oracle-databaseplsqloracle11gcommit

See changes of a different SQL Oracle session before COMMIT?

I coordinated the implementation of an Oracle PL/SQL DML script, but to do that in Production I usually would reach out to a DBA Team for them to run the script, provided they have the appropriate permissions.

Is there a way for my user to see the changes prior he actually COMMITs them? I know the changes will be active in the session that executed the script, but is there a way for a different session, & moreover, a different user to see them?

Solution

  • There is no way for one session to see changes made by another until they are committed.