sql run okay using sqlplus command prompt but reports syntax errors when attempt using toad

hello expert,

I have quite a few sql

I can run same via sqlplus prompt no error reported

and they all execute okay.

when i attempt to run same sql via toad for oracle (freeware)

a series or syntax errors are reported

could any say how i can convert these queries so

it can run successful using toad.



below is sample


column num1 format $9,999,999,999.00  heading '   CURRENT BAL  '
column num3 format $9,999,999.00      heading '     ARREARS   '
column num4 format 9,999.00          heading ' REPAYMENT '
break on report skip 2
set head off
select    'MORTGAGE GENERAL ARREARS LIST
                                        date :'|| to_char(sysdate,'dd/mm/yyyy')
from v$parameter
where name = 'db_name';
set head on
compute sum of num1 on report
compute sum of num3 on report
compute sum of num4 on report
select substr(loan_acc.acc_no,1,12)"ACCOUNT ",
substr(prop_name,1,5)"AREA ", substr(acc_name,1,20)"     NAME",
sum(curbal)                  num1,
sum(loan_finl.arrbal)        num3,
sum(pay_inarr2)              num4
from loan_acc, loan_finl, altern_acc,arr_accxt, prop_sec, address
where loan_acc.acc_no= altern_acc.acc_no
and loan_acc.acc_no = loan_finl.acc_no
and loan_acc.acc_no = arr_accxt.acc_no
and prop_sec.address = address.address
and loan_acc.acc_no = prop_sec.bus_id
and loan_acc.close_date is null
and loan_finl.arrbal < 0.00
and pay_inarr2 > 0.01
and arr_meth ='A'
and loan_acc.branch between '&branch' and '&branch'
group by loan_acc.acc_no,acc_name,prop_name
/

Start Free Trial