Re: Oracle Insert Data from one table to another table using Groovy

2016-07-28 Thread GroovyBeginner
Thanks !! It worked -- View this message in context: http://groovy.329449.n5.nabble.com/Oracle-Insert-Data-from-one-table-to-another-table-using-Groovy-tp5734285p5734338.html Sent from the Groovy Dev mailing list archive at Nabble.com.

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-28 Thread Dinko Srkoč
") > { row-> > sql.executeInsert "INSERT INTO A (ID, Name) VALUES ($row.ID,$row.Name)" > } > > > > -- > View this message in context: > http://groovy.329449.n5.nabble.com/Oracle-Insert-Data-from-one-table-to-another-table-using-Groovy-tp5734285p5734303.html > Sent from the Groovy Dev mailing list archive at Nabble.com.

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-27 Thread Michael Tetzlaff
from A where ID not in (select id from B)") { row-> sql.executeInsert "INSERT INTO A (ID, Name) VALUES ($row.ID,$row.Name)" } -- View this message in context: http://groovy.329449.n5.nabble.com/Oracle-Insert-Data-from-one-table-to-another-table-using-Groovy-tp5734285p5734

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-27 Thread GroovyBeginner
t; } -- View this message in context: http://groovy.329449.n5.nabble.com/Oracle-Insert-Data-from-one-table-to-another-table-using-Groovy-tp5734285p5734303.html Sent from the Groovy Dev mailing list archive at Nabble.com.

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread Russel Winder
It does seem a pity that Groovy only provides drivers of SQL statements when Groovy is a language superb for DSLs and builders. Python is very similar to Groovy in this respect and Python has SQLAlchemy which provides the low level SQL driving stuff, but also provides an expression language, DSL a

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread Dinko Srkoč
e.callsite.GetEffectivePojoPropertySite.getProperty(GetEffectivePojoPropertySite.java:63) > > at > org.codehaus.groovy.runtime.callsite.AbstractCallSite.callGetProperty(AbstractCallSite.java:291) > > at ConsoleScript1$_run_closure1.doCall(ConsoleScript1:8) > > > > > -- > View this message in context: > http://g

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread GroovyBeginner
message in context: http://groovy.329449.n5.nabble.com/Oracle-Insert-Data-from-one-table-to-another-table-using-Groovy-tp5734285p5734298.html Sent from the Groovy Dev mailing list archive at Nabble.com.

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread ngalarneau
erpolation From: GroovyBeginner To: d...@groovy.incubator.apache.org, Date: 07/26/2016 02:46 AM Subject: Oracle Insert Data from one table to another table using Groovy I have a requirement of inserting the data from table A into table B and am using Oracle database. My co

Re: Oracle Insert Data from one table to another table using Groovy

2016-07-26 Thread Jochen Theodorou
On 26.07.2016 08:46, GroovyBeginner wrote: I have a requirement of inserting the data from table A into table B and am using Oracle database. My condition is am going to insert only those records which are not present in table B and am facing an issue of retrieving the current row column values

Oracle Insert Data from one table to another table using Groovy

2016-07-25 Thread GroovyBeginner
lso is there any better approach of doing this in terms of security and performance. -- View this message in context: http://groovy.329449.n5.nabble.com/Oracle-Insert-Data-from-one-table-to-another-table-using-Groovy-tp5734285.html Sent from the Groovy Dev mailing list archive at Nabble.com.