Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: What is the best PLSQL solution to this problem?

Re: What is the best PLSQL solution to this problem?

From: Frank <franjoe_at_frisurf.no>
Date: Wed, 20 Jun 2001 17:29:55 +0200
Message-ID: <Mk3Y6.3161$_96.130848@news3.oke.nextra.no> 






Hi!



Might this be what  you are looking for?
Standard package with Oracle8; DBMS_UTIL



From doc


"



COMMA_TO_TABLE procedure


This procedure converts a comma-separated list of names into a PL/SQL table
of names. This uses NAME_TOKENIZE to figure out what are names and what are
commas.



Syntax


DBMS_UTILITY.COMMA_TO_TABLE


   list   IN  VARCHAR2,


   tablen OUT BINARY_INTEGER,


   tab    OUT UNCL_ARRAY);


"



Frank
Received on Wed Jun 20 2001 - 10:29:55 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US