Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re:real newbie question (i think)
Rich,
Since no one has yet posted an answer, here is my opinion/questions.
Dick Goulet
____________________Reply Separator____________________ Author: Rich Davidson <RDavidson_at_dynamicsoft.com> Date: 11/14/2001 5:30 AM
hey all,
i'm in your typical situation of "we don't need a dba...oracle is an app so the bizapps guy can handle it"....right...now to reality. there is a column in our database (oracle is the back end of our crm package) that is defined as a long and they want to do keyword searches on it. i've found out that you can't use type long in a where clause.
i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion. am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change.
right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier.
thanks in advance for the help and not being a dba i hope what i wrote makes
sense!
*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:
rich davidson
dynamicsoft Inc.
east hanover, nj
rdavidson_at_dynamicsoft.com
t. +1-973-503-6169
f. +1-973-952-5050
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>how to extract text from LONG field</TITLE>
<META content="MSHTML 6.00.2600.0" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2>hey all<SPAN
class=540272013-14112001>,</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=540272013-14112001></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=540272013-14112001>i'm in your typical situation of "we don't
need a dba...oracle is an app so the bizapps guy can handle it"....right...now to reality. there is a column in our database (oracle is the back end
of our crm package) that is defined as a long and they want to do keyword
searches on it. i've found out that you can't use type long in a where
clause.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=540272013-14112001></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=540272013-14112001>i guess i have a few questions and i'm
going to assume the answers (if anyone answers...please oh please do) will be a
matter of opinion. am i better off creating a new column in the existing
table of the type clob or blob? should i create a new table to store this
data? and what would be my best way to keep these columns in sync...every
time someone updated the long column i would want my new column updated to
reflect the change.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=540272013-14112001></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=540272013-14112001>right now we're on 8.0.6/win 2k...but
could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this
process easier.</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN
class=540272013-14112001></SPAN></FONT></FONT></FONT></SPAN> </DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=540272013-14112001>thanks in advance for the help and not
being a dba i hope what i wrote makes
sense!</SPAN></FONT></FONT></FONT></SPAN></DIV>
<DIV><SPAN class=540272013-14112001><FONT face=Arial><FONT color=#0000ff><FONT
size=2><SPAN class=540272013-14112001>
<P><FONT face="Courier New"
size=2>*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-:</FONT> <BR><FONT face=Arial
size=2>rich davidson</FONT> <BR><FONT face=Arial size=2>dynamicsoft Inc.</FONT>
<BR><FONT face=Arial size=2>east hanover, nj</FONT> </P>
<P><FONT face=Arial size=2>rdavidson_at_dynamicsoft.com</FONT> <BR><FONT face=Arial
size=2>t. +1-973-503-6169</FONT> <BR><FONT face=Arial size=2>f.
+1-973-952-5050</FONT>
</P></SPAN></FONT></FONT></FONT></SPAN></DIV></BODY></HTML>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Nov 14 2001 - 13:40:53 CST
![]() |
![]() |