Advertisement

05.09.2008 at 10:39PM PDT, ID: 23391329
[x]
Attachment Details

Searching full or part of string passed (from the front end)in the text stored into column of data type VARCHAR2(4000)

Asked by dnabatra in PL / SQL, Oracle Database, Oracle 9.x

Tags: Oracle, Oracle, 9i, Search Utility, Oracle, 9i

I would like to create a search utility (oracle procedure)  to find out the match of a string in the text column.  If it finds out the exact match then it should return at the top saying it 100% match..If it finds the part of the string, then it should dislay the text with its percentage.  For example,  match a string like 'Pain in Leg' with 'Leg Pain' .

Please suggest.Start Free Trial
[+][-]05.10.2008 at 04:01AM PDT, ID: 21538477

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.10.2008 at 06:05AM PDT, ID: 21538904

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.10.2008 at 06:08AM PDT, ID: 21538909

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.10.2008 at 08:25AM PDT, ID: 21539375

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.11.2008 at 04:09AM PDT, ID: 21542092

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.11.2008 at 06:01AM PDT, ID: 21542356

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.11.2008 at 01:40PM PDT, ID: 21543423

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]05.11.2008 at 09:04PM PDT, ID: 21544594

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]05.12.2008 at 12:00AM PDT, ID: 21545033

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: PL / SQL, Oracle Database, Oracle 9.x
Tags: Oracle, Oracle, 9i, Search Utility, Oracle, 9i
Sign Up Now!
Solution Provided By: schwertner
Participating Experts: 4
Solution Grade: B
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628