摘要： 例1：传递表名，和Where条件删除数据CREATE OR REPLACE PROCEDURE raise_emp_salary (column_value NUMBER, emp_column VARCHAR2, amount NUMBER) IS v_column VARCHAR2(30); sql_stmt VARCHAR2(200);BEGIN-- determine if a valid column name has been given as input SELECT COLUMN_NAME INTO v_co... 阅读全文

摘要： SQLServer的场合,用";"分割SQL语句即可正常执行。Oracle的场合，会报ORA-00911错误。Oracle中需要加上beginend才正确。 Dim Sql As String = "" Sql = Sql & " BEGIN " Sql = Sql & vbCrLf Sql = Sql & " insert into tableA (col1,col2,col3) values ('a','a','a');" Sql = Sq 阅读全文