在oracle8.0.5中:
用dbms_sql来实现
CREATE OR REPLACE PROCEDURE demo(salary IN NUMBER) AS
cursor_name INTEGER;
rows_processed INTEGER;
BEGIN
cursor_name := dbms_sql.open_cursor;
DBMS_SQL.PARSE(cursor_name, 'DELETE FROM emp WHERE sal > :x',
dbms_sql.native);
DBMS_SQL.BIND_VARIABLE(cursor_name, ':x', salary);
rows_processed := dbms_sql.execute(cursor_name);
DBMS_SQL.close_cursor(cursor_name);
EXCEPTION
WHEN OTHERS THEN
DBMS_SQL.CLOSE_CURSOR(cursor_name);
END;
用dbms_sql来实现
CREATE OR REPLACE PROCEDURE demo(salary IN NUMBER) AS
cursor_name INTEGER;
rows_processed INTEGER;
BEGIN
cursor_name := dbms_sql.open_cursor;
DBMS_SQL.PARSE(cursor_name, 'DELETE FROM emp WHERE sal > :x',
dbms_sql.native);
DBMS_SQL.BIND_VARIABLE(cursor_name, ':x', salary);
rows_processed := dbms_sql.execute(cursor_name);
DBMS_SQL.close_cursor(cursor_name);
EXCEPTION
WHEN OTHERS THEN
DBMS_SQL.CLOSE_CURSOR(cursor_name);
END;
解决方案 »
- 高分求助:oracle10g 运行一段时间后速度变慢问题
- SQL语句 在PLSQL中运行后 ,会引发在程序中阻塞的问题
- 求健壮的数字和字母混合编码的算法代码
- 急求一个数据更新的SQL语句
- 执行alter table ... shrink space时出现的错误
- 怎么修改ORACLE的APACHE的端口???
- 如何使用vc存取oracle中的图象数据?
- 如何使用SmartQurey或者OraQuary读取Oracle表内容
- 数据表空间的导入问题
- 奖励100分(ORA-12571)
- sequence的值在没有进行select nextval操作时,数据库本身会使它增长吗?
- 如何去掉字符串中的光标(回车符号)
1。定义一字符变量strSql varchar(200);
2。连接字符串strSql:='select * from '||tbl||' where name=''HUA''';
3。执行语句execute immediate strSql;