<FONT
size=2>hey all<SPAN
class=540272013-14112001>,
<FONT
size=2><SPAN
class=540272013-14112001>
<FONT
size=2>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.
<FONT
size=2><SPAN
class=540272013-14112001>
<FONT
size=2>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.
<FONT
size=2><SPAN
class=540272013-14112001>
<FONT
size=2>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.
<FONT
size=2><SPAN
class=540272013-14112001>
<FONT
size=2>thanks in advance for the help and not
being a dba i hope what i wrote makes
sense!
<FONT
size=2>
<FONT face="Courier New"
size=2>*:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-: <FONT face=Arial
size=2>rich davidson dynamicsoft Inc.
east hanover, nj
rdavidson_at_dynamicsoft.com <FONT face=Arial
size=2>t. +1-973-503-6169 f.
+1-973-952-5050
Received on Wed Nov 14 2001 - 07:53:25 CST
