| NOT IN command question.. [message #449249] |
Sun, 28 March 2010 22:04  |
Oskar28
Messages: 2
Registered: February 2010
Location: Philippines
|
Junior Member |
|
|
Is this possible?..
SELECT DISTINCT A.column
INTO v_column
FROM TABLE_SAMPLE A
WHERE A.column NOT IN (variable)
variable contains 1,2,3,4
it does not work for me.. do you have some suggestions or alternative way of doing it..
|
|
|
|
| Re: NOT IN command question.. [message #449250 is a reply to message #449249] |
Sun, 28 March 2010 22:10  |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
>variable contains 1,2,3,4
It is BAD, POOR, & UNDESIRABLE to store more than 1 value in a single column/variable.
Solution suffers from wrong design.
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
SELECT DISTINCT A.column
INTO v_column
FROM TABLE_SAMPLE A
WHERE A.column NOT IN (1,2,3,4);
[Updated on: Sun, 28 March 2010 22:11] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
