The delete from the table
commit;
After the data is still in
Oracle 9 I server
The client is Oracle 8.1.7
Up sqlplus don't commit can delete
CodePudding user response:
The delete from the table.commit;
Add a delete statement after;
Or do you use to truncate
CodePudding user response:
The delete from the table.commit; If you don't succeed, you see how much is your SQLcode
CodePudding user response:
The delete from the Table where... ;If the sqlca. Sqlcode=0 then
commit;
The else
The rollback.
//or see error messages,
endif