Re:real newbie question (i think)

From: <dgoulet_at_vicr.com>
Date: Wed, 14 Nov 2001 11:40:53 -0800
Message-ID: <F001.003C4ECE.20011114112322@fatcity.com>

Rich,

Since no one has yet posted an answer, here is my opinion/questions.

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.
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 <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><FONT
size=2>hey all,</DIV>
<DIV><FONT
size=2> </DIV>
<DIV><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.</DIV>
<DIV><FONT
size=2> </DIV>
<DIV><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.</DIV>
<DIV><FONT
size=2> </DIV>
<DIV><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.</DIV>
<DIV><FONT
size=2> </DIV>
<DIV><FONT
size=2>thanks in advance for the help and not being a dba i hope what i wrote makes
sense!</DIV>
<DIV><FONT
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
</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