What's the alternative of "MERGE w/ INSERT ALL"?

What's the alternative of "MERGE w/ INSERT ALL"?

set wrap off;
MERGE INTO ACCESSABILITY_PLAY."Sessional Data" s USING (SELECT '990989971' "Student ID", '1234-12F' "Session" FROM DUAL) sc
ON (sc."Student ID" = s."Student ID" AND sc."Session"=s."Session") WHEN MATCHED THEN UPDATE SET
s."College Affiliation" = 'TESTING Havard University' WHEN NOT MATCHED THEN
INSERT ALL
INTO "Students" ("Student ID") VALUES ('990989971') INTO "Sessional Data" ("Student ID", "Session", "College Affiliation",
"ft-pt", "Program Major1", "Program Major2", "Program Minor1", "Program
Minor2", "No of credits to date", "No of courses", "Academic Status",
"docReviewDate", "Review Date", "ReleaseInfoSignedDate",

						"OSAP BSWD FaxedStGeorge", 						"Date Given Centre Handbook",
			"Date Release of PA signed", 				"Summary Notes", "ESF Notes",


"Sessional ID", "OSAP Eligible", "esf", "Current Year" )

VALUES ('990989971', '1234-12F', 'TESTING Havard U', 		 'a',
'b',							 'c', 							'd', 							'e', 						'f', 											'g',
						'h', 								'i', 						to_date('1983-01-01', 'YYYY-MM-DD'),
to_date('1983-01-01', 'YYYY-MM-DD'), to_date('1983-01-01',
'YYYY-MM-DD'), to_date('1983-01-01', 'YYYY-MM-DD'),
to_date('1983-01-01', 'YYYY-MM-DD'), 'j', 						'k',
				sessional_id.nextval, 								0, 0, 0)

It is killing me,
I've heard it is not possible to use merge and insert all together. thx a bunch;) Received on Fri Nov 24 2006 - 14:52:25 CST