I face problems to extract data from one table and insert it in another one

Posted on 16th Feb 2014 07:03 pm by admin

Hi,

For modifications, I have to extract data from one table and insert it in another one, after this I have to get the new id from the second table and place it in the first table.

More or less, it should be so:

For every record loop
select law_item from table_one;
insert law_item into table_two;
insert into table one(law_id) values(table_two_sequence.currval);
End loop;

I saw (and I tried) many thing on Internet... (as type, bulk collect...) but did not succeeded in it.
Does anybody have a solution ?

Thank you in advance

Your Answer:

Login to answer

Other forums

form submit at godaddy?
Trying to test form submission at GoDaddy and it does not seem to work. Here's the page...

h

Beginners syntax and loop questions - help please!
Hi everyone,

I have some problems with php code. I'm currently in the middle of learning php,

code help - pagination
Hi all, I have this code, basically a user logs into my site and they get this page.

The pro

multiple recipients + dbuser mail recall
Hello,

I am building a php login script.

When the user registers the script will send

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

script is pulling more then they have....
I have this script for my game where they can change there race. This will cost them 2,500 points. H

Inserting the current date/time while submitting the forum
What do I need to add below to update the current date/time? I have a field in the database called d

Linux socket programming
Where can I find a good introduction to socket programming?

Array disappearing in foreach loop
Okay, I have this problem where an array will become undefined in a foreach loop.

Here is the

How to show a complete textarea ??
I enter Client Case Notes notes in a textarea field on a PHP form. The field is 5 rows deep and 70 c