选择输入参数中的Oracle多个字段 [英] Oracle multiple fields in Select IN Parameter
本文介绍了选择输入参数中的Oracle多个字段的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Select * FROM STUDENT
WHERE (student.course, student.major) IN (SELECT schedule.course, schedule.major
FROM schedule)
如果我必须提供静态值,查询将是什么样?因为我正在根据输入参数从中间层传递SQL.
What if i have to provide static values, what would be the query like? Because I am passing the SQL from a middle layer based on input parameters.
我正在寻找基于多组值进行搜索的方法.例如.
I am looking to search based on multiple sets of values. For ex.
Select * FROM STUDENT
WHERE (student.course, student.major) IN
(('MBA', 'Computers'), ('BA', 'Computers'))
推荐答案
我很确定您可以使用此功能:
I'm pretty sure you can use this:
Select * FROM STUDENT
WHERE (student.course, student.major)
IN (SELECT 'MBA', 'Computers' from DUAL
union SELECT 'BA', 'Computers' from DUAL);
:D
这篇关于选择输入参数中的Oracle多个字段的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文