I am not sure you can merge the same table to itself. With PK constraint the first record goes through and the second record is rejected. So the whole transaction is aborted.
Thanks dbalearner. I have got a copy of Transact SQL Programming Guidelines and it is by far the best Transact SQL practical book I have seen for years.
I changed a parameter in Oracle with scope spfile. I had to shutdown Oracle and when I startup I get startup error. How can I sort out the problem. I need to remove the wrong parameter setting from spfile. My problem is that my pfile makes a reference to spfile as follows...
Hi
A semaphore is an interprocess communication (IPC) in UNIX. Semaphore is basically is a hardware or software flag used to prevent processes from accessing the same shared memory space at the same time. When a process has control of a shared memory resource, all other processes are locked out...
Hi,
I am finding out about my oracle environment and I want to know the command utility on Solaris 8 to know what semaphores being used. What is a simple description of semaphore.
thanks
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.