Please help with this SQL Plus problem. Thank you.
a) Create a very small table called MyBAL. It should have just one column, called BAL, with datatype NUMBER(5,2). Set the initial value of BAL to 123.45: This is your bank balance in dollars. There is only one row in this table.
b) Use SQLplus directly (not a script) for all the following parts of this problem. Say SHOW AUTOCOMMIT (In SQLplus). It'll probably say ON. If it does, say SET AUTOCOMMIT OFF (SQLplus normally, by default, commits whatever you do as soon as you do it. You don't have to say COMMIT to make sure that your action really got done. But we want that feature turned off here.)
SELECT * (or SELECT BAL) from MyBAL. What is your current balance?
c) Update your BAL to be 456.78. Run SELECT to show your (apparent) balance now. What is it?
d) Say ROLLBACK. Then do SELECT again. What is your BAL now? Explain what happened.
e) Update your BAL to be 777.77. Do SELECT. What BAL does it show?
f) Say SAVEPOINT MySnapshot.
g) Update your BAL to be 33.33. Do SELECT. What is your BAL now?
h) Also, save in SQL: ROLLBACK TO MySnapshot. Do SELECT. What is your BAL now? Explain or summarize what happened in the above sequence of f, g, h, and i.
i) Say in SQLplus: COMMIT. Also, go ahead and say SET AUTOCOMMIT ON (Just so nothing funny happens as you continue to use SQLplus during this session.)