Dear all I am very new in this industry please help me I want to insert the data from one table to another table how I write the syntax
Dear all I am very new in this industry please help me I want to insert the data from one table to another table how I write the syntax
Hi muhammad,
1. You can use either class or runnable class to insert data from one table to another.
Syntax,
//iniatialize buffer for the table. Table table1; Table table2; //Depending on the number of record you can use select or while select.. While select * from table1 { table2.value = table1.value; ..... ..... table2.insert(); }
Thanks,
Girish S.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,269 Super User 2024 Season 2
Martin Dráb 230,198 Most Valuable Professional
nmaenpaa 101,156