May I know how to get the execution plan for update statement in oracle database?
Please help me out as soon as possible.
Thanks in advance.
No Comments Posted for this Article.
Oracle Database Deadlock
Hi, I am adding one update statement in the existing trigger on same table. So it gave an error mutating error. After that I added pragma autonomous transaction and after that it is throwing...
Backup Database (Oracle 10g XE)
What I am dong is - set the ARCHIVLOG ON (which was off previously) from SQL COMMAND LINE Then I took the backup from - Backup Database. The result is - Doing online backup of the...
How Insert Operation works in Oracle Database.
Hello Experts, I know the architecture of oracle database. I know the SELECT and DELETE operation and how it works in oracle architecture. But i want to know how INSERT operation will work in...