OraFAQ Forum: Server Administration » selecting LIKE from LONG datatype?

Home » RDBMS Server » Server Administration » selecting LIKE from LONG datatype?

Thu, 14 June 2001 10:51

Iain
Messages: 4
Registered: October 2000

Junior Member

Is it possible to

SELECT foo
INTO bar
FROM table
WHERE baz LIKE '%stuff%';

where baz is a LONG datatype?

Cheers

Fri, 15 June 2001 18:41

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

No, LONG goes up to 2 GB. In PL/SQL though, LONG variables hold up to 32k. If your data is less then that, then see the following...

http://www.classicity.com/oracle/htdocs/forums/ClsyForumID125/7.html

http://www.classicity.com/oracle/htdocs/forums/ClsyForumID125/8.html#

Fri, 22 June 2001 20:23

palanikarupaiyan@hotmail.
Messages: 18
Registered: June 2001

Junior Member

in PL/SQL , if declare the variable bar
as Varchar2, it can handle upto 4gb.

Palani.

Previous Topic:	Entering a character return in a memo field
Next Topic:	Re: How to retrieve the latest query executed in oracle

Goto Forum:

]

Current Time: Wed Jul 03 03:49:34 CDT 2024