Searching a LONG field

From: Kim Butler <xkmd_at_uxa.ecn.bgu.edu>
Date: 6 Jul 1993 10:55:07 -0500
Message-ID: <21c78r$hto_at_uxa.ecn.bgu.edu>

Using ORACLE Version 6, is it possible to search a database for all records which have a specified word in a LONG or CHAR(255) field? For example, each record in the database consists of 2 fields:

TICKET of type NUMBER(6)
DESCRIPTION of type LONG or of type CHAR(255)

I want to retrieve each record which contains the word "programming". Can I do this in ORACLE Version 6?

Any solutions or suggestions would be greatly appreciated.

Thanks,

Kim Butler
xkmd_at_uxa.ecn.bgu.edu Received on Tue Jul 06 1993 - 17:55:07 CEST

This message: [ Message body ]
Next message: David R. Barstis: "Need Help With SQL*Forms and Nextval"
Previous message: Zhou Jian: "Install SQL*Forms30 -- help needed"
Next in thread: hazledine_at_embl-heidelberg.de: "Re: Searching a LONG field"
Reply: Yves Noel: "Re: Searching a LONG field"
Reply: hazledine_at_embl-heidelberg.de: "Re: Searching a LONG field"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message