Home » Server Options » Text & interMedia » Find Words in a String (11g Release 2 Windows)
Find Words in a String [message #618415] |
Fri, 11 July 2014 10:15 |
Duane
Messages: 557 Registered: December 2002
|
Senior Member |
|
|
Anyone have a query that can find WORDS in a String and break out those words?
User types in "George Washington" into an input field and that string is passed to an Oracle procedure where the words are split out.
It's also possible that a user could type in "George Washington DC" so it's not always limited to just 2 words.
Input_String = 'George Washington';
procedure XYZ (Input_String in varchar2,
Results out sys_refcursor)
begin
open Results for
select column1,
column2,
column3,
.
.
column20
from presidents_table
where first_name = WORD1 or
last_name = WORD2
end
|
|
|
|
|
Find Words in a String
By: Duane on Fri, 11 July 2014 10:15
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Fri, 11 July 2014 11:00
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Fri, 11 July 2014 11:33
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Mon, 14 July 2014 08:30
|
|
|
Re: Find Words in a String
By: Duane on Mon, 21 July 2014 16:12
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Thu, 24 July 2014 16:12
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Fri, 25 July 2014 09:43
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Fri, 25 July 2014 12:08
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Fri, 25 July 2014 15:59
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Sat, 12 July 2014 13:58
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Sat, 12 July 2014 15:18
|
|
|
Re: Find Words in a String
By: Duane on Sat, 12 July 2014 16:04
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Sat, 12 July 2014 17:06
|
|
|
temp topic to be merged don't reply in it.
By: Duane on Sat, 12 July 2014 10:47
|
|
|
Re: Find Words in a String
|
|
|
Re: Find Words in a String
By: Duane on Sat, 12 July 2014 11:45
|
|
|
Re: Find Words in a String
|
Goto Forum:
Current Time: Thu Mar 28 05:25:03 CDT 2024
|