Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How compare CHAR and VARCHAR2

How compare CHAR and VARCHAR2

From: Andriy Shafar <cutwater_at_wp.pl>
Date: Thu, 28 Apr 2005 00:00:51 +0200
Message-ID: <d4p22h$nph$1@galaxy.uci.agh.edu.pl>


Hi.

I have a problem.

How I can compare CHAR and VARCHAR2?

EX.
column_char CHAR(10);
column_varchar2 VARCHAR2(10);
SELECT * FROM tab WHERE column_char LIKE column_varchar2.

Thanks.

-- 
Andriy Shafar
Received on Wed Apr 27 2005 - 17:00:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US