论坛 › Oracle运维 › Oracle9i的索引分类

whitek 发表于 2018-9-23 06:13:06

Oracle9i的索引分类

　　Select * from customer where substr(cust_name,1,4) = ‘BURL’;
　　Select * from customer where to_char(order_date,’MM’) = ’01;
　　Select * from customer where upper(cust_name) = ‘JONES’;
　　Select * from customer where initcap(first_name) = ‘Mike’;

查看完整版本: Oracle9i的索引分类