Question
EXERCISE 9-3 Work with Transactions and Flashback Query In this exercise, youll demonstrate the manner in which undo data is used to provide transaction isolation
EXERCISE 9-3
Work with Transactions and Flashback Query
In this exercise, youll demonstrate the manner in which undo data is used to provide transaction isolation and rollback as well as to implement flashback query. Use the REGIONS table in the HR demonstration schema. Here are the steps to follow:
1. Connect to the HR schema with two sessions, concurrently. These can be two SQL*Plus sessions, two SQL Developer sessions, or one of each. This table lists the steps to follow in each session:
BOOK: OCA Oracle installation 12c and administration page 307
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Database Programming Languages 12th International Symposium Dbpl 2009 Lyon France August 2009 Proceedings Lncs 5708
Authors: Philippa Gardner ,Floris Geerts
2009th Edition
3642037925, 978-3642037924
