March 18, 2014 at 11:19 pm
Hi,
Please help me how to create package upsert industry and want to do update and insert operations from database.
March 18, 2014 at 11:29 pm
Thats are vary open question you have asked. there is no a detail regarding what kind of problem you are facing. Kindly share us what exactly you are looking for.
March 19, 2014 at 4:05 am
The command you're looking for in T-SQL is called MERGE. Here's the Books Online entry on it.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 19, 2014 at 10:23 pm
Hi ,
Thank you. Can you explain in detail about creating a pkg and in precedure how to create pl/sql codings for insert alone from the given source table. can u send me any other documents for referrence?
March 20, 2014 at 3:57 am
jeni.jm23 (3/19/2014)
Hi ,Thank you. Can you explain in detail about creating a pkg and in precedure how to create pl/sql codings for insert alone from the given source table. can u send me any other documents for referrence?
No, sorry, I can't. Package and PL/SQL are Oracle and I work with SQL Server. The forum you're posting in is for SQL Server 2014. You'd be better off taking your question to an Oracle forum.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply