RE: I dont get this...

From: Lyall Barbour <lyallbarbour_at_sanfranmail.com>
Date: Sat, 17 Jun 2000 00:23:49 -0400 (EDT)
Message-Id: <10530.109641@fatcity.com>

I have no idea.
But, if I were to guess at something, maybe its the place you put the escape '/'.

Try moving it around maybe after the and profile = 1.

select profile from user_profile where nickname like 'kc\_%' and profile = 1 escape '/';

HTH
Lyall Barbour

------Original Message------

From: Calvin Lim <calvin-lim_at_mediaring.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: June 16, 2000 11:45:11 PM GMT
Subject: I dont get this...

Hi,

I dont quite understand why the below queries are behaving this way. profile is of type number and nickname is of type varchar2. I select profile based on the pattern 'kc\_%' (escaping _ with \) and have 21 hits. But when i further qualify with profile=1, i get zilch. Why? I'm puzzled and need your help. Thanks..

Regards,
Calvin

---

SQL> select profile from user_profile where nickname like 'kc\_%' escape '\';

PROFILE

---

1
1
1
1
1
1
1
1
1
1
1

PROFILE

---

1
1
1
1
1
1
1
1
1
1

21 rows selected.

SQL> select profile from user_profile where nickname like 'kc\_%' escape '\'

and                 profile=1;

no rows selected

-----BEGIN PGP PUBLIC KEY BLOCK-----

Version: PGPfreeware 6.0.2i

mQENAziIKPcAAAEIAMOziD1YcgivJCdmdMaQftSrMhnL6uXjz9Fh6c2FjDbEwLb1 gHAYk8bdlaWLPspacuwo5mjzCc5uUvNualORP+tLxGNY9GiMdHMUfUdNLxv7EU4+ 6WxaXwyzz5DZUQiwLsvg12+ZSLOuOL4BLu8oJH9MBSPa/9aaYGDpQ845L6JJP5t1 uDDsG26k6gnenOfT+ZaEgFTFpYQbfXN7X16dc726AcEuSG8NUjK3thA3ol9m8768 cCELkc82w55HNH5b4TeF9obapJrXgOLqnf2pi4mUodao5dFewW/U46zPcz2giRp4 gVPAmJFs+s8OjKY74D3aXH7QWg7bLrLOrBG3pkUABRG0L0NhbHZpbiBMaW0gU3dl ZSBLaGlhbmcgPGNhbHZpbl9saW1AaG90bWFpbC5jb20+iQEVAwUQOIgo9y6yzqwR t6ZFAQFrTAf+Lw6aI0wSfOooU1n9qw0zdL4o0U4ZH+XAgzn8BoVcv0U1bA0U1ckg pDY5TVfR0hQg7DQyUvh1AKxeD9D6OTFpg/TE3BPD49iq/LS3uuUbfIGmhsE6AmM1 SiRwwmA5n5IZTWDYHrocBJegV5Hk3iHJeDjCKvX/CZCZH4CGJ/2y/THfa6I9eDfF kmZ8f90cM4hZ9YiqLSslNf5hztJZzEfBuSs7Zz6tHRQFlCucn5mlKPNM+ig4FBdS f6ISUMxQxZB2xbFwYDn+qjB6eF8HianPP7XCQUSQNJeWKQ9pkJ7QOZeEKvRYZHp2 tLNw34pJ8cHoOIGS7FAi+OX2IfyyOvehkw==
=FOMk
-----END PGP PUBLIC KEY BLOCK-----

--
Author: Calvin Lim
INET: calvin-lim_at_mediaring.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

______________________________________________

Received on Fri Jun 16 2000 - 23:23:49 CDT