This content has been marked as final. Show 3 replies
You are trying to retrieve the data by giving the condition on BLOB Datatype using the Function "regexp_like". BLOB contains binary data. We cannot use this Function on this type of Columns.
Moreover, we cannot retrieve the data of BLOB Columns using SELECT Statements. We have to use other GUI Environment for retrieving such Columns Data from the Table.
Hi T0t0shka ,
We get this Error, because the data types are Incompatible.
Use, Proper Conversion functions TO_NUMBER,TO_CHAR,TO_DATE to their appropriate data types.
We Often get this error, if we have a Table with Data type LONG also.
CREATE TABLE LONG_TABLE ( A LONG, B VARCHAR2(10) );
When you Perform a SELECT as
WHERE b LIKE '%sj%';
We wont get error.
WHERE a LIKE '%sj%';
We get Inconsistent datatypes error.