DECLARE
my_task_name VARCHAR2 (30);
my_sqltext CLOB;
BEGIN
my_sqltext := 'select * from student where sex="m"'; //这一句有错,应该怎么写啊
my_task_name := dbms_sqltune.create_tuning_task (sql_text=> my_sqltext,
bind_list => null,
user_name => 'STAT',
scope => 'COMPREHENSIVE',
time_limit => 60,
task_name => 'vega_tuning_task',
description => 'Tuning Task'
);
END;
/
my_task_name VARCHAR2 (30);
my_sqltext CLOB;
BEGIN
my_sqltext := 'select * from student where sex="m"'; //这一句有错,应该怎么写啊
my_task_name := dbms_sqltune.create_tuning_task (sql_text=> my_sqltext,
bind_list => null,
user_name => 'STAT',
scope => 'COMPREHENSIVE',
time_limit => 60,
task_name => 'vega_tuning_task',
description => 'Tuning Task'
);
END;
/
解决方案 »
- [forms builder]跳转窗口或者切换文本框,光标总是等待3秒
- 大虾们,请问SQL中调用PL/SQL函数时运行原理是怎么样的?谢谢
- 哪位兄弟有OracleXE 10.2 linux 64 bit的安装程序?
- 如何把大数据量(约40G)从10G导到9i
- between and 的返回值是什么?
- 备份与恢复oracle数据库的方法与步骤?
- OracleOraDb10g_home1TNSListener 服务问题?
- 怎么执行啊?dbmslmd.sql
- 并发问题,有一个字段 a 设为PRIMARY KEY 两个用户同时添加字段时的问题
- 重赏之下必有勇夫:jdbc能访问本机数据库吗?
- SQL 急急
- oracle9i数字字符串排序
'select * from student where sex=m';这样都不行,@它就发生错误
同#1