statement & transaction

[smdakram]

!hi

Iam unable to understand what is the difference between

STATEMENT AND TRANSACTION ?

can u please solve my question with example .....

[shailendra]

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

[helpme]

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.