Answer / ganesh sawant from finacle

oracle allows many session to work simultaneously and store computer rescues. To have multiple session oracle has control concurrency i.e. maintain data integrity when multiple sessions access the same data at same time.

For example consider a railway reservation system where table is maintained and showing availability of reservation .
Oracle controls the concurrency using locking

explain advantages of innodb over myisam. : Sql dba

0 Answers  

---

need to split a string into separate values. eg. col1 col2 ---------- 100 - 'a,b,c' 200 - 'a,x,d,e' 300 - 'c' result: value count ------------- a - 2 b - 1 c - 2 etc.

2 Answers  

---

Is join an inner join?

0 Answers  

---

I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,

---

what is the command used to fetch first 5 characters of the string? : Sql dba

0 Answers  

---

---

what is sql server agent? : Sql dba

0 Answers  

---

Do we need commit after truncate?

0 Answers  

---

How many rows can sqlite handle?

0 Answers  

---

What is the difference between pl and sql?

0 Answers  

---

What is the starting oracle error number?

0 Answers  

---

What is sql performance tuning?

0 Answers  

---

How can I pass the inner procedure value to outer procedure ?

2 Answers  

---