Re: Query from long paragraph

From: David <darussell_at_msn.com>
Date: Sat, 18 Apr 1998 21:28:19 +0100
Message-ID: <OyWZUiwa9GA.228@uppubnews03>

If you are using Oracle7 then you can either use context option or arrange you tables such that you have a master record in one table and another table of detail rows (each of 2000 bytes).

If you are using Oracle8 you can use the context cartridge, CLOB's or varchar2(4000) columns, I would recommend the CLOB's.

Regards
David Russell

Min Wang wrote in message <3537D35E.BE08E537_at_colorbank.com>...
>We want to query from text paragraphs which are longer than 2000 bytes.
>What's the best way to do it?
>Thanks.
>
>--
>Min Wang
>E-mail: mwang_at_colorbank.com
>http://www.colorbank.com/
>http://www.shopfast.com/
>
>
>
Received on Sat Apr 18 1998 - 15:28:19 CDT