Home » SQL & PL/SQL » SQL & PL/SQL » Using Long Datatype
Using Long Datatype [message #21418] Fri, 02 August 2002 01:58 Go to next message
mousie
Messages: 9
Registered: March 2002
Junior Member
Hi everybody;

How can I do to perform string manipulation in a long datatype column ? I just want know if a word is present in a column's value ; but problem is that this column is a Long datatype. There's something like instr('ACFBCAC','AC',1,1) to use with a long datatype column ?

Thank you

Report message to a moderator

Re: Using Long Datatype [message #21423 is a reply to message #21418] Fri, 02 August 2002 04:52 Go to previous messageGo to next message
venkatesh
Messages: 72
Registered: August 2000
Member
hi

you cannot do any string manipulation in long datatype...

venki

Report message to a moderator

Re: Using Long Datatype [message #21426 is a reply to message #21418] Fri, 02 August 2002 06:09 Go to previous message
mousie
Messages: 9
Registered: March 2002
Junior Member
I do it ; but it doesn't work ; Oracle raises VALUE ERROR exception

Report message to a moderator

Previous Topic: datatype help
Next Topic: Link errors
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 09:10:30 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.