返回数说广场
0
在oracle中创建如下表和索引,以下能使用上索引的SQL有哪些?ADE
create table test as select * from dba_objects;
create index ind_test_sub_name on test(substr(object_name,1,3));
A select * from test where substr(object_name,1, 3)='TES';
B select * from test where substr(object_name,0,3)='TES';
C select * from test where substr(object_name,1,2)='TE';
D select * from test where substr(OBJECT_NAME,1,3)='TES';
E select * from test where substr(object_name,1,3)='TES';
0
0 229
分享
评论
热门数说


