Re: How to split string variable
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Fri, 25 Nov 2011 12:26:42 +0000
Message-ID: <4ECF8982.7010508_at_dunbar-it.co.uk>
On 25/11/11 10:34, Eriovaldo Andrietta wrote:
> I have this:
> 1:002:3:04:xyz:5:777:67:000:11
Date: Fri, 25 Nov 2011 12:26:42 +0000
Message-ID: <4ECF8982.7010508_at_dunbar-it.co.uk>
On 25/11/11 10:34, Eriovaldo Andrietta wrote:
> I have this:
> 1:002:3:04:xyz:5:777:67:000:11
Are you looking to be able to treat the result of such a split as a "table" so that it can be used in an IN or similar? Or do you just want to split a (non first normal form) string into constituent parts?
For example :
Select <stuff> from <table>
where <a column> in split_my_string(..)
Cheers,
Norm.
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 25 2011 - 06:26:42 CST