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.
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.