-
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
col1 col2
x y
I need to insert two records
one with col1 value 'x'
and other record with col2 value y.
format will be table2
row1 x
row2 y
please put saome light on it
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|