More Than One Insert In One Go
hI ..how can we do 2 inserts in a cursor...?
suppose i hav two columns col1 and col 2
i want to create two records based on the values present in both colmns at the same time.
So wat should I do?
For ex table 1
I need to insert two records
one with col1 value 'x'
and other record with col2 value y.
format will be table2
please put saome light on it
Wondering if when you say "at the same time" you are actually meaning "in the same transaction" in which case I would ask... what's the problem?
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
Click Here to Expand Forum to Full Width