let me explain i have 4 column in a table test_no(autogenerate),test_date(text),test_cycle_No(number),test_day(number)
so now the problem is test no as i said is autogenerating ,test_cycle_no and test_day this two column value are already in database ,but i have to generate and insert date column value externalyy...
i have written code for generating date values
but i want that this date values should be inserted here in this table ,consisting of all this columns.
so what query should i write ????