OraFAQ Forum: Server Administration » Comparison in Long Field

Home » RDBMS Server » Server Administration » Comparison in Long Field

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

Comparison in Long Field [message #119237]

Wed, 11 May 2005 07:29

win_vj
Messages: 16
Registered: March 2005
Location: India

Junior Member

Hi All,

I have a Long field in a table. I just want to search all those values, which contain 'Battery*'. Is there any function for that?

Thanks....

Vijay Kumar

Report message to a moderator

Re: Comparison in Long Field [message #119239 is a reply to message #119237]

Wed, 11 May 2005 07:54

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

HI

Use the following clause in SQL query:

where <field_name> like '%Battery*%'

regds
Girish

Report message to a moderator

Re: Comparison in Long Field [message #119267 is a reply to message #119239]

Wed, 11 May 2005 09:15

win_vj
Messages: 16
Registered: March 2005
Location: India

Junior Member

Girish,

I think Long field cannot be used in Where clause.

Thanks....
Vijay Kumar

Report message to a moderator

Re: Comparison in Long Field [message #119294 is a reply to message #119239]

Wed, 11 May 2005 11:31

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Yes u r right Vijay

Sorry for the earlier miscommunication.

Theres lot of restrictions with LONG datatype.

One possible way is:
Do a select on the fields that have this LONG datatype. Insert them into a new table, but instead of using the LONG datatype use a CLOB datatype in the new table.

More info can be obtained at
http://www.orafaq.com/forum/m/16225/0/?srch=long+datatype#msg_16225
and
http://www.orafaq.com/forum/m/116608/0/?srch=long+datatype#msg_116608

Report message to a moderator

Previous Topic:	New instance or new user ...
Next Topic:	initialization parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 04:39:15 CST 2025