From owner-oracle-l@CCVM.SUNYSB.EDU Thu Mar 16 18:35:42 1995 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65/1.1.8.2/01Aug94-0142PM) id AA06283; Thu, 16 Mar 1995 18:35:38 -0500 Message-Id: <9503162335.AA06283@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by CCVM.sunysb.edu (IBM VM SMTP V2R2) with BSMTP id 3057; Thu, 16 Mar 95 17:57:00 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 4038; Thu, 16 Mar 1995 13:49:47 -0500 Date: Thu, 16 Mar 1995 13:15:21 -0500 Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: "Jan Baumgras, 566 Bldg., 6-0443" Subject: Searching "LONGS" X-To: ORACLE-L@ccvm.sunysb.edu To: Multiple recipients of list ORACLE-L If anyone knows how to search long fields directly using Forms functionality, I'd love to see the answers too! Here's the best I know of. I know two ways to "search" long fields, neither of which involve just using SQL*Forms. The question was not specific about how you want to do matches, so I include both methods to let the reader judge which you'd prefer. Long fields can be indexed using SQL*Textretrieval (STR). You can then either use STR to search the long fields or query the STR tables from Forms. STR does pretty well at standard word searching but does have some limitations. The other way is to use a user exit and write your own search routine loading the long field into a variable and use the string manipulation of the language to perform your search. Some languages are obviously better for this than others. Jan