Separating value fields from one column to multiple column
| From: | Hendri | Date: | Mon, 28 Apr 2003 06:11:40 +0000 |
| Subject: | Separating value fields from one column to multiple column | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-27397@lists.php.net to get a copy of this message | ||
Hi, Everyone..
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
How Can it be?
Thanks...
--
Hendri 'cacem'
Hobbys Programmer
MCP (Microsoft Certified Pirate)