!hi
Iam unable to understand what is the difference between
STATEMENT AND TRANSACTION ?
can u please solve my question with example .....
Printable View
!hi
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
for example
statement : = select * from tab;
transaction :=
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);
commit;
Shailendra
insert into a1 values (1);
insert into a1 values (2);
insert into a1 values (3);
all 3 above are statements!!!
COMMIT;
usin commit,the changes made by the group of above statements above r made permanant....this is a TRANSACTION.