This is simplified but, assume an Oracle table like
tblNumbers(id, dt_crte, num1, num2, num3) and a Java ArrayList like [1,3,7],
How would I write the Java code to produce the following table values:
id = 1, dt_crte = 2015-03-02, num1 = 1, num2 = 3, num3 = 7) where the id would be sequential, the dt_crte todays date (i.e. date() if from Java or sysdate if from Oracle) and the num columns equivalent to the indexed columns of the ArrayList?