Re: Searching a LONG field

In article <21c78r$hto_at_uxa.ecn.bgu.edu>, xkmd_at_uxa.ecn.bgu.edu (Kim Butler) writes:
|> 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

• You can try this SQL statement : select * from <table_name> where description like '%programming%';

  ---

  NOEL Yves | Phone : 33.20.43.42.70 Oracle DBA | Fax : 33.20.43.66.25 C.I.T.I. | Email : noel_at_citilille.fr Universite des Sciences & Technologies de Lille | 59655 Villeneuve d'Ascq Cedex - FRANCE |

  ---

  • I use ORACLE v6.0.36 on DEC RISC ULTRIX v4.3 ----

    ---