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

Home -> Community -> Usenet -> c.d.o.misc -> dynamic pl/sql

dynamic pl/sql

From: MD <md_at_md.com>
Date: Fri, 6 Oct 2006 16:12:09 -0500
Message-ID: <IEzVg.2378$b23.811@dukeread07>


hi ng,

is there a way to pass a list of items into a package or procedure?

for example...
i want to return some field where name = 'Mark', 'John', 'Mike' -- this list will NOT contain a set number of items

create procedure test
vList varchar2
as
Select *
From table
Where name is in vList (can i use instr and say -- Where instr(vList, name) > 0)



OR

can pl/sql be built in the procedure and be run? declare vSQL varchar2
vSQL = "Select * from table"
execute vSQL

thanks in advance,
MarkD Received on Fri Oct 06 2006 - 16:12:09 CDT

Original text of this message

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