SQL> create table l(x varchar(10);
create table l(x varchar(10)
*
第 1 行出现错误:
ORA-00907: 缺失右括号
SQL> 1
1* create table l(x varchar(10)
SQL> a)
1* create table l(x varchar(10))
SQL> /
表已创建。
SQL> insert into l select 'aaa'||level from dual connect by level<=100;
已创建 100 行。
SQL> create index lx on l(x);
索引已创建。
SQL> select * from l where l like 'aaa99%';
select * from l where l like 'aaa99%'
*
第 1 行出现错误:
ORA-00904: "L": 标识符无效
SQL> set autot on
SP2-0618: 无法找到会话标识符。启用检查 PLUSTRACE 角色
SP2-0611: 启用 STATISTICS 报告时出错
SQL> select * from l where x like 'aaa99%';
X
----------
aaa99
执行计划
----------------------------------------------------------
Plan hash value: 3145445051
-------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |
-------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | 1 | 7 | 1 (0)| 00:00:01 |
|* 1 | INDEX RANGE SCAN| LX | 1 | 7 | 1 (0)| 00:00:01 |
-------------------------------------------------------------------------
Predicate Information (identified by operation id):
---------------------------------------------------
1 - access("X" LIKE 'aaa99%')
filter("X" LIKE 'aaa99%')
Note
-----
- dynamic sampling used for this statement (level=2)