Iam unable to understand what is the difference between
STATEMENT AND TRANSACTION ?
can u please solve my question with example .....
As of my knowledge statement is a set of commands while transaction is a set of statements
statement : = select * from tab;
select * from tab;
insert into table_name1 (column_name) values (values);
insert into table_name2 (column_name) values (values);
insert into table_name3 (column_name) values (values);
insert into a1 values (1);
insert into a1 values (2);
insert into a1 values (3);
all 3 above are statements!!!
usin commit,the changes made by the group of above statements above r made permanant....this is a TRANSACTION.
Click Here to Expand Forum to Full Width