Re: Use of 'like' in where clause.
Hi,
What I specifically wanted to know was the difference between
where col_name like 'A%'
and
where 'A%' like col_name.
The second where clause is returinng me more rows than the first.
Can somebody guide me on this?
Thanks,
Aswathy
Subject
Views
Written By
Posted
8015
April 21, 2005 10:00AM
2850
April 22, 2005 07:31AM
Re: Use of 'like' in where clause.
2481
April 22, 2005 09:22AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.