Why can't you insert a row into table with first two columns and do update for that row???
Just for simple work around, I have created a table with below columns,
I wrote a below code to insert a row into that table,
insert into test_group(user_name,exam_date) values (:APP_USER,sysdate);
FOR i IN 1..v_arr.COUNT LOOP
if v_arr(i) is null then
v_stmt:='update test_group set m'||i||'=NULL';
v_stmt:='update test_group set m'||i||'='||v_arr(i);
execute immediate v_stmt;
I just ran this block in 'SQL Commands', It worked for me. but i inserted only one row, so it updates a single row, In case of multiple row need to use the unique column for update. change the above code as per your requirement.
I hope this work around will help you. If not can you please create an example in apex.oracle.com and share login credentials.
That totally worked.
Question: Is there a way to do it all at once though?
Let's say there are 100 questions. That would be 101 hits on the DB, verses 1.
Your question is not clear..can you please make it clear??
If possible create an example in apex.oracle.com and share your credential.