选择输入参数中的Oracle多个字段 [英] Oracle multiple fields in Select IN Parameter

问题描述

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屋！