Hi All,
I need to write a Oracle stored procedure which takes a
String as its input.The string will contain characters separated by a character such as tilde(~),for example,String s = shashi~raju.Inside the procedure,the string should be split into several strings without the separator character.These strings should be set as input in the where clause of a SQL select statement in the procedure.The output of the procedure should be a table containing the resultant rows.How to go about this using Oracle PL/SQL?A example would be very useful for me.Thanks in advance.
