返回数说广场
0
在oracle中创建如下表和索引,以下能使用上索引的SQL有哪些?
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,1,2)='TE';
C select * from test where substr(OBJECT_NAME,1,3)='TES';
D select * from test where substr(object_name,0,3)='TES';
E select * from test where substr(object_name,1, 3)='TES';
ACE
0
0 281
分享
评论
热门数说


