Re: FUNCTION.

One approach is to use object types.

There is an item on my web-site that I wrote in early 8.0 days. Use the CAST() operator to convert an input string into an object table of values, then use the TABLE()
operator (once the THE()) operator to
insert it into your table.

Check under:

    Miscellaneous -> In Lists

Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

|
|-----Original Message-----
|Sent: Wednesday, March 27, 2002 5:18 PM
|To: Multiple recipients of list ORACLE-L
|
|
|HI LIST,
|
|I need some help to write a function or procedure to insert into a
table,
|the input of this function will be a comma delimiter string like
|(aaa,bbbc,d,f,ggg) and the the result would be 4 records inserted
into the
|table.the number of input could be diffrent.
|
|tableA
|------------------------
|1 aaa
|2 bbbc
|3 d
|4 f
|5 ggg
|------------------------
|Thanks in Advance,
|
|

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jonathan Lewis
  INET: jonathan_at_jlcomp.demon.co.uk

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).