Showing posts with label DDL. Show all posts
Showing posts with label DDL. Show all posts

Jul 15, 2009

Instead of Commit

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);