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