oracle 反向索引

create index ix_ba_emp_code_re on t_base_employee(reverse(employee_code));

select * from t_base_employee t where t.employee_code like 'dss%' or reverse(t.employee_code) like reverse('%ddd')

 

posted @ 2018-03-18 15:46  zfzf1  阅读(134)  评论(0编辑  收藏  举报