Re: Split String
Posted by:
anci wasim
Date: August 23, 2008 04:33PM
i found a best way, and it works for me,
my string like : cast ="2|3|5|6|7"
i have replace string with "," and now i can use this into IN statement.
SELECT REPLACE( cast, "|", "," ) AS casts FROM sng_movie_album WHERE 6
IN (REPLACE( cast, "|", "," ))
Thanks, its working for me..
Subject
Written By
Posted
December 17, 2007 09:46AM
February 20, 2008 12:29PM
Re: Split String
August 23, 2008 04:33PM
September 08, 2008 04:27AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.