dbms_sqltune问题再问

[ebeyondboy]

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;
/

[shiyiwan]

'select * from student where sex=''m''';

[ebeyondboy]

我是这样写的，在txt里的， -ORA-00904:"m":标示符

[shiyiwan]

不能用双引号

[ebeyondboy]

'select * from student where sex='m'';
'select * from student where sex=m';

这样都不行，@它就发生错误

[shiyiwan]

#4

m少了一对单引号

'select * from student where sex=''m''';
同#1

[iqlife]

''m'' 是两个单引号