So why are you asking on a PHP list? Find an oracle list/help board and ask there. ---John W. Holmes... PHP Architect - A monthly magazine for PHP Professionals. Get your copy today. http://www.phparch.com/ > -----Original Message----- > From: Hendri [mailto:c4c3m@myrealbox.com] > Sent: Monday, April 28, 2003 3:01 AM > To: holmes072000@charter.net > Cc: php-db@lists.php.net > Subject: Re: RE: Separating value fields from one column to > multiple column > > i mean in oracle, because its to much data in that table > > -----Original Message----- > From: "John W. Holmes" <holmes072000@charter.net> > To: "'Hendri'" <c4c3m@myrealbox.com>, "'php'" <php-db@lists.php.net> > Date: Mon, 28 Apr 2003 02:09:59 -0400 > Subject: RE: Separating value fields from one column to multiple > column > > > I have a big trouble maintaining fields in Oracle, My Case is : > > in one field 's_misc' it contains value with "()" separation: > > (Name)(Address)(Proffesion) > > > > Then i want to separate this value to another column to > > > > s_name > > s_address > > s_proffesion > > $elements = explode(')(',substr($s_misc,1,-1)); > > That'll give you each of the values inside of the parenthesis in an > array. This is after you pull the value out of oracle, btw. > > ---John W. Holmes... > > PHP Architect - A monthly magazine for PHP Professionals. Get your copy > today. http://www.phparch.com/ > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
