File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases 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
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
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?
I agree. Here's the link:
subject: Searching words in VARCHAR2 & CLOB
It's not a secret anymore!