Meaningless Drivel is fun!*
The moose likes JDBC and the fly likes Searching words in VARCHAR2 & CLOB Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Searching words in VARCHAR2 & CLOB" Watch "Searching words in VARCHAR2 & CLOB" New topic

Searching words in VARCHAR2 & CLOB

yashendra chandrakar

Joined: Mar 22, 2002
Posts: 22
i m using jdbc2.0,Oracle8.I want to provide search facility to client,for that i need to search client entered words in database table columns(with datatype VARCHAR2 & CLOB).should i get all the rows in resultset then serch that words usning jdbc method methods like
int position(String searchtext) of Clob class?
Or can i use any SQL query for that search so that i get only required rows in resultset?
It is sorta covered in the JavaRanch Style Guide.
subject: Searching words in VARCHAR2 & CLOB
Similar Threads
Need help on Stored Procedure Call with CLOB as IN Parameters
Size of ResultSet
SetCharachterStream seems not to work with MySQL
Question on update CLOB column when the column value is null
Searching words in VARCHAR2 & CLOB