Like displays rows which doesn't match the condition or am i wrong.
From: Veerabasaiah C <veeracb_at_gmail.com>
Date: Fri, 14 Mar 2014 10:46:50 +1300
Message-ID: <CAKE9HuMVvNNCiVLDH57Eozc6XXrzAN+HSijvfHY7godUaWQ_Sg_at_mail.gmail.com>
SQL> select * from test where c1 like 'a1_%';
a1a4
Date: Fri, 14 Mar 2014 10:46:50 +1300
Message-ID: <CAKE9HuMVvNNCiVLDH57Eozc6XXrzAN+HSijvfHY7godUaWQ_Sg_at_mail.gmail.com>
SQL> select * from test where c1 like 'a1_%';
C1
a1_a2 a1_a3 a1_a4
SQL> insert into test values('a1a4');
1 row created.
SQL> select * from test where c1 like 'a1_%';
C1
a1_a2 a1_a3 a1_a4
a1a4
SQL> In the above select like displays "a1a4", for the search criteria it should display anything with the "a1_" but the last row doesn't even have a underscore.
--
Veerabasaiah C B
"Only put off until tomorrow what you are willing to die having left
undone. - Picasso"
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Mar 13 2014 - 22:46:50 CET