下面我试图打印存储在input.lst中的输出a.poid_id0应存储在一个变量中a.Account_obj_id0应该存储在另一个变量中b.BILL_INFO_ID应存储…
你可以尝试以下 col1,col2,col3等应该是你的变量:
output=$(sqlplus -S ${DB_STRING} << EOF select a.poid_id0,a.Account_obj_id0, b.BILL_INFO_ID,b.PAYINFO_OBJ_ID0,b.poid_id0 from ACCT_IBAN_ASSOCIATION_T a, billinfo_t b where a.ACCOUNT_OBJ_ID0 = b.ACCOUNT_OBJ_ID0 and b.BILL_INFO_ID !='Account Bill'; SPOOL OFF EOF ) echo -e "$output" | while read col1 col2 col3 (etc..) ; do ... ; done