Oracle: how can I parameterize a list?

Question

I have a query with a where clause that looks like this:

WHERE field IN ( 1, 2, 3 )

It is possible to parameterize this so that it looks something like this:

WHERE field in (: list)?

How do you create: parameter list, considering it a list of ints, which can be from 1 to 10 ints?

ASP.net, webforms, if that matters.

Answer 1

Same answer as SQL Server already set here: Parameterizing SQL IN Clause

Answer 2

There are two ways to place dynamic lists:

• Convert comma separated list to view (AKA built-in view)
• SQL

---

SQL- - . :

WHERE :list LIKE '%,' || t.column || ',%'

... , :

• ,

, . , Oracle 10g +, ,

SQL

---

" SQL", , , SQL-. .

, SQL .

Answer 3

, . .

, ASP.NET :

WHERE field IN (:list1, :list2, :list3, :list4)

Answer 4

: " ?", , .

"" Oracle - , :

API HibernateCritera Oracle -

, , Tom Kyte, Oracle!