CREATE OR REPLACE PROCEDURE P1 (a in varchar2) is
view_str varchar2(1000);
begin
view_str:='create or replace view as ...';
execute immediate view_str;
end;
在ORACLE中有一个如上的过程;
Dim Conn As ADODB.Connection
Dim Cmd As ADODB.Command
Dim Param As ADODB.Parameter
Set Conn = New ADODB.Connection
Set Cmd = New ADODB.Command