How to use ON DUPLICATE KEY in insert statement.
In case of inserting or updating record we use separate logic using if statement or case statement:
e.g.:
if(i==0)
insert here
if(i=1)
update here
we can terminate the above if statement by using On Duplica ...(description truncated)

Oracle R12 P2P Accounting and Troubleshooting Noted - by Dinesh Kumar S
In this material i have explained about the accounting entries generation and the setups involved for the same. How these counting entries are transferred from Sub-Ledger to GL. Also, ...(description truncated)

My nonprogramming sites: The Real Estate Crowdfunding Review: Investing tools that cut through the clutter and the hype.
Real information and reviews. Real-time investment feeds. Real profitable. | Dollar candy: Play 60 second puzzles against three other people for real money! Legal in 36 states and overseas.