string matching with trailing space
From: Gary Beckler <gbeckler_at_easystreet.com>
Date: Mon, 10 Sep 2001 06:22:40 -0700
Message-ID: <tppfhoae8l5cfb_at_corp.supernews.com>
How does Oracle perform string matching with trailing spaces in the following example?
Date: Mon, 10 Sep 2001 06:22:40 -0700
Message-ID: <tppfhoae8l5cfb_at_corp.supernews.com>
How does Oracle perform string matching with trailing spaces in the following example?
CREATE TABLE a(
dept CHAR(6);
INSERT INTO a VALUES ('Labor ');
SELECT * FROM aWHERE dept IN ('Labor');
Will a string match occur?
Thanks,
Gary
Received on Mon Sep 10 2001 - 15:22:40 CEST