GLOBAL TEMPORARY TABLE over Views in advantages insolving
mutating error?
- 1 Answers
- 3165 Views
- Virtusa, I also Faced
- E-Mail Answers
Answer Posted / 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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Can we use distinct and group by together?
Does group by remove duplicates?
what is schema? : Sql dba
what are the advantages of sql ? : Sql dba
Can delete statement be rollbacked?
Is primary key clustered index?
what is dbms? : Sql dba
What is the best sql course?
how to use regular expression in pattern match conditions? : Sql dba
What is the current version of sql?
What is your daily office routine?
If a cursor is open, how can we find in a pl/sql block?
How do I remove duplicates in two columns?
Do we need to rebuild index after truncate?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
