On 3/28/19 3:23 AM, Sameer Kumar wrote:[snip]> You can write a query with upper function:>> select * from emp where upper(ename)=upper('aaa');
That's a guaranteed table scan.
-- Angular momentum makes the world go 'round.