Hey All,
I'm converting some data in Oracle 9i...
Specifically a filed that currently holds *gasp* a comma-seperated value list
Does anyone have a function handy that would accept the list as an argument and
then loop over the elements in the list so I can insert each value into a new
tabe where each value will be in a seperate record like it should be??
The CF equivalent is:
<cfset MyListColumn = "1,2,3,4,5,6,7,8">
<cfloop list="#MyListColumn#" index="currVal">
INSERT INTO MyTable
(
MyField
)
VALUES
(
#currVal#
)
</cfloop>
So I need some PL/SQL to take a column in as "MyListColumn" and then loop over
that list referencing each element (I can handle the insert myself).
Thanks in advance
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213931
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
