Usually after a DML statement to make the change permenantly in the database we should execute commit statement .
Example
update scott.emp t where t.JOB='ff' where EMPNO=7654 ;
commit;
If we execute a DML statement and then DDL statement then without executing commit statement the effect of DML statement will save permenantly in the database
Example
update scott.emp t where t.JOB='ff' where EMPNO=7654 ;
create table test(test1 number);
No comments:
Post a Comment