OraFAQ Forum: SQL & PL/SQL » How to use LIKE function for LONG datatype

Home » SQL & PL/SQL » SQL & PL/SQL » How to use LIKE function for LONG datatype

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to use LIKE function for LONG datatype [message #19824]

Thu, 11 April 2002 06:44

Skumar
Messages: 17
Registered: April 2002

Junior Member

select text from user_view where text like '%ABD%';

Report message to a moderator

LIKE for LONG datatype is imposible [message #19833 is a reply to message #19824]

Thu, 11 April 2002 21:35

Elic
Messages: 3
Registered: April 2002

Junior Member

RTFM Oracle SQL Reference | Datatypes | LONG Datatype:
...
LONG columns cannot appear in certain parts of SQL statements:
...
- SQL functions (such as SUBSTR or INSTR)
- Expressions or conditions
...

Report message to a moderator

Re: LIKE for LONG datatype is imposible [message #20635 is a reply to message #19824]

Mon, 10 June 2002 05:12

Memo
Messages: 2
Registered: May 2002

Junior Member

LIKE for LONG datatype is imposible

Report message to a moderator

Previous Topic:	TRIGGER
Next Topic:	CASE in pl/sql

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 05:47:45 CDT 2024