 | |
SELECT Question
comp.databases.oracle.server comp.databases.oracle.server
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
SELECT Question -
06-17-2008
, 11:27 AM
#2
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? *How would you do that? *The column in the table is numeric. *Do I have to 'build' the select statement? Thanks! John |
-g
#3
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? *How would you do that? *The column in the table is numeric. *Do I have to 'build' the select statement? Thanks! John |
-g
#4
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? *How would you do that? *The column in the table is numeric. *Do I have to 'build' the select statement? Thanks! John |
-g
#5
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? *How would you do that? *The column in the table is numeric. *Do I have to 'build' the select statement? Thanks! John |
-g
#6
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? *How would you do that? *The column in the table is numeric. *Do I have to 'build' the select statement? Thanks! John |
-g
#7
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? *How would you do that? *The column in the table is numeric. *Do I have to 'build' the select statement? Thanks! John |
-g
#8
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? *How would you do that? *The column in the table is numeric. *Do I have to 'build' the select statement? Thanks! John |
-g
#9
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? How would you do that? The column in the table is numeric. Do I have to 'build' the select statement? Thanks! John |
-g
-------------------------------------
Or write a function returning 1 if the value is ok, 0 if not and use
where your_function(var) = 1;
You can't build an index on it, though (not even function based, because the
function is not deterministic)
Shakespeare
#10
| |||
| |||
|
|
Hi, Quick question here, if I have a WHERE clause with an IN condition - WHERE var IN (1, 2, 3)...... What if the list is dynamic? How would you do that? The column in the table is numeric. Do I have to 'build' the select statement? Thanks! John |
-g
-------------------------------------
Or write a function returning 1 if the value is ok, 0 if not and use
where your_function(var) = 1;
You can't build an index on it, though (not even function based, because the
function is not deterministic)
Shakespeare
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.