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