oracle取sql的返回值,oracle – 从sql脚本返回值到shell脚本

我有shell脚本调用以下sql脚本：

INSERT INTO SEMANTIC.COUNT_STATISTICS (...);

UPDATE SEMANTIC.COUNT_STATISTICS

SET PRNCT_CHANGE = 1.1;

--want to store result of this bellow select statement in model_count variable

select PRNCT_CHANGE

FROM SEMANTIC.COUNT_STATISTICS

WHERE model = '&MY_MODEL'

AND NEW_DATE = (

select max(NEW_DATE)

from SEMANTIC.COUNT_STATISTICS

where MODEL = '&MY_MODEL'

);

现在,如何将此PERCENTAGE_NUMBER变量返回到我的shell脚本？

我的shell脚本如下：

#!/bin/bash

#

# setup oracle, java, and d2rq environment

. /etc/profile.d/oracle.sh

. /etc/profile.d/java.sh

. /etc/profile.d/d2rq.sh

cd /opt/D2RQ

model_count=$(sqlplus user/pass @count.sql 'MODEL')

if ["$model_count" > 0]; then

echo "percentage count is positive"

else

echo "its negative"

我想将最后一个SELECT语句结果存储到shell脚本中的model_count变量中.

谁知道为什么不工作？