SQL ORDER BY“IF”(SQL ORDER BY “IF”)

 链接的重复问题APC显示了一个工作示例，但澄清您有两个问题。 第一个是非致命的，只是你没有EOF ，正如Rembunator指出的那样 
 
   （尽管它在答案中的位置错误） 
  。 
 
 更重要的是，虽然你没有终止; 在您的查询中，因此SQL * Plus不会执行它 - 它只是退出而没有输出。 
 
 如果您在SQL * Plus命令提示符下键入原始查询，它会让您在另一个提示符处等待输入，如果您再次点击return，则返回正常提示符，而不实际执行查询： 
 
SQL> select billcycle from bc_run
  2  where billcycle not in (50,16)
  3  and control_group_ind is null
  4  and billseqno=6043
  5
SQL> 
 
 您可能还需要至少一些输出格式。 所以这应该工作： 
 
v_bc=`sqlplus -s /@bscsprod <<EOF
set pagesize 0
select billcycle from bc_run
where billcycle not in (50,16)
and control_group_ind is null
and billseqno=6043;
EOF`

The duplicate question APC linked to shows a working example, but to clarify you have two problems. The first is non-fatal and is just that you don't have EOF, as Rembunator pointed out 
 
   (though it's in the wrong place in that answer) 
 .
 
More importantly though you don't have a terminating ; in your query, so SQL*Plus won't execute it - it just exits with no output. 
 
If you typed your original query in as the SQL*Plus command prompt it would leave you at a further prompt waiting for input, and then go back to a normal prompt if you just hit return again, without actually executing the query:
 
SQL> select billcycle from bc_run
  2  where billcycle not in (50,16)
  3  and control_group_ind is null
  4  and billseqno=6043
  5
SQL> 
 
You also probably want at least some formatting of the output. So this should work:
 
v_bc=`sqlplus -s /@bscsprod <<EOF
set pagesize 0
select billcycle from bc_run
where billcycle not in (50,16)
and control_group_ind is null
and billseqno=6043;
EOF`