Answer / Akash Deep Maurya

Global temporary tables have several advantages when it comes to solving mutating conflicts, as they are visible only within the session that created them. Using global temporary tables can help isolate changes made by different sessions and prevent issues such as deadlocks or inconsistent data due to concurrent modifications. In comparison, views do not provide this level of isolation, making them more susceptible to mutating conflicts.

Can dml statements be used in pl/sql?

1 Answers  

---

HOW TO ADD PRIMARY KEY TO TABLE BY PL/SQL PROGRAM

3 Answers  

---

What is an exception in PL/SQL? What are the two types of exceptions?

1 Answers  

---

how to start mysql server? : Sql dba

0 Answers  

---

What is the difference between mdf and ndf files?

1 Answers  

---

How will you debug your procedure? If your procedure is around 2000 lines and the expected output is 10 and we get only output 5.So how will you debug it? Somebody pls give the correct answer?

2 Answers   Fidelity,

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

1 Answers  

---

What is sql partition?

1 Answers  

---

What is Function based Index and which type of function we can use in Function base index. can we use aggregate,NVL function in Function based Index..

1 Answers   Metric Stream, Polaris,

---

Why schema is used in sql?

1 Answers  

---

Wat is SGA ?

3 Answers   ABB,

---

how to create a database in oracle?

3 Answers  

---