Answer / reddibasha

Transaction is a Set of DML operations with Commit /
Rollback. In SQL, transaction starts with DML command
(Except SELECT) and ends with Commit / Rollback(Implicit /
Explicit).

Answer / pavan_1981

set of related dml operations to perform a task are called
a transaction.

Answer / dawood

It starts with a first executable statement and ends when
commit or rollback statement occurs.

Answer / aravind

Transaction is a logical unit of work that comprises of one
or more sql statements.

Answer / ashok

All the DML operations between two COMMIT points can be called as a Transaction and Oracle server handles this as a single unit

How can I get the number of records affected by a stored procedure?

0 Answers  

I have a procedure in a procedure. The inner procedure contains out parameter. How I can call the inner procedure in the out procedure and send the inner procedure parameter value(out parameter value) into out procedure?

2 Answers  

What is the reports view in oracle sql developer?

0 Answers  

Are sql connections encrypted?

0 Answers  

Mention what plvcmt and plvrb does in pl/sql?

0 Answers  

how to create a test table in your mysql server? : Sql dba

0 Answers  

What has stored procedures in sql?

0 Answers  

What are the dml statements?

0 Answers  

Is sql a dbms?

0 Answers  

If 100 tables are there in user_tables.I want to find in which table zero records are there with table name.Is it possible?

2 Answers  

Can we create a trigger on view?

0 Answers  

Explain two easy sql optimizations.

0 Answers