Help everybody, how to determine the batch execution results, the sample is as follows:

 string ls_sql 
Ls_sql="DELETE tableA WHERE ID IN (... );" & 
+ "INSERT tableA (columnA, columnB,... ) SELECT A, B,... The FROM tableB 
"The EXECUTE IMMEDIATE: ls_sql; 

CodePudding user response:

Suggest writing stored procedures,

CodePudding user response:

SQL is the dynamic consolidation, write a stored procedure is not convenient

CodePudding user response:

refer to the second floor TSSCEO response:

SQL is of dynamic consolidation, write a stored procedure is not convenient

Don't want to do it is the individual treatment of SQL sentence by sentence,