Hi folks,

I'm looking to pick everyone's brains.

I have a cursor, with over 200 columns in the select.

I am using a case in one of the columns which I'm retrieving, and want to issue an insert statement within this. i know people will come back with different merge or whatever, but i must be able to do this within a case statement unfortunately.

example

CURSOR c_student_data...