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

What is pls integer?

0 Answers  

---

Explain the commit statement.

0 Answers  

---

can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)

5 Answers  

---

How does left join work in sql?

0 Answers  

---

Is sql a programming?

0 Answers  

---

---

table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  

---

what is auto increment? : Sql dba

0 Answers  

---

What is the diff between Truncate table / delete <table name> purge

3 Answers   TCS,

---

Do we need to rebuild index after truncate?

0 Answers  

---

full outer join syntax

5 Answers  

---

what is meant by urlencode and urldocode? : Sql dba

0 Answers  

---

What are the different types of dbms?

0 Answers  

---