c**t
发帖数: 2744 | 1 Oracle (10g), table A (id, Node, ...), where id, Node combination is unique.
How to query if Node1, Node2, ... with id1 exists where Node1,Node2.., id1
are parameters (inputs)? | c**t
发帖数: 2744 | 2 select ID, Node
from
(
select id1 as ID, Node1 as Node from dual
union
select id1, Node2 from dual
..
)
minus
select id, Node from A where id=id1
??
unique.
【在 c**t 的大作中提到】
: Oracle (10g), table A (id, Node, ...), where id, Node combination is unique.
: How to query if Node1, Node2, ... with id1 exists where Node1,Node2.., id1
: are parameters (inputs)?
|
|
