暂无图片
返回数说广场
1
18626038518
2022-08-24
在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
分享

评论

热门数说