strsql := 'select count(*) from ' || tablename; execute immediate strsql into a;
用动态SQLCREATE OR REPLACE PROCEDURE Test1 IS v_Sql VARCHAR2(200); Cursor_create VARCHAR2(100); Result NUMBER; BEGIN v_Sql := ' CREATE TABLE T1 ( A VARCHAR2(200) ) ';
cursor_create := dbms_sql.open_cursor; DBMS_SQL.PARSE(cursor_create, v_SQL,dbms_sql.native); Result := dbms_sql.EXECUTE(cursor_create); DBMS_SQL.close_cursor(cursor_create);
execute immediate strsql into a;
v_Sql VARCHAR2(200);
Cursor_create VARCHAR2(100);
Result NUMBER;
BEGIN
v_Sql := '
CREATE TABLE T1
(
A VARCHAR2(200)
)
';
cursor_create := dbms_sql.open_cursor;
DBMS_SQL.PARSE(cursor_create, v_SQL,dbms_sql.native);
Result := dbms_sql.EXECUTE(cursor_create);
DBMS_SQL.close_cursor(cursor_create);