Hi Dick...
Here are some thoughts...
1) You can't use the like operator on the LONG datatype... You will get an
inconsistent datatype error...
2) A bunch of reasons...
a) LONG are going away someday
b) You can store LOB data out of line with the table to improve
performance
c) You can more than one LOB per table
d) You can partition a table with LOB's but not one with a LONG
e) LOB's support random access to the data
f) There a bunch of built in functions to access LOB's ( check out
the DBMS_LOB package )
Tim
-----Original Message-----
Sent: Wednesday, November 14, 2001 2:23 PM
To: Multiple recipients of list ORACLE-L
Rich,
Since no one has yet posted an answer, here is my opinion/questions.
1) Why do you want the 'new column'? What it looks like it that you
just
need to query the table for the keywords your interested in. The 'like'
operator shoudl work just fine.
2) A long can contain 2GB worth of data, why on earth would you want to
use
a CLOB or BLOB?
Dick Goulet
____________________Reply Separator____________________
Author: Rich Davidson <[EMAIL PROTECTED]>
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
[EMAIL PROTECTED]
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>[EMAIL PROTECTED]</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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnston, Tim
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
