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

problem with php server update from mid 2009
Hi,

I have this navigation menu on 2 websites which used to work just fine. After a recent up

getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI

This is driving me nuts!
This insert query looks to be alright, however I get this error:

QuoteYou have an error in yo

Using two $_POST Function / Switch () statements, second does not work.
Hi all. I’m new to php and am having a problem getting $_POST Function / switch () to work. I

please help me in this update statment
hi every one

if I have table and this data in it

id name
10

Help on query replacing the date
Hi Pals,

i want to replace the current date in a column to some value say C or D or any n

php mysql query from input textbox
Hi,

I have a text box, in that i have given the mysql query. I can able to get the query in v

Displaying a clickable playername
I am going wrong somewhere with the mysql_query, can someone please put me straight?

$playern

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai