you will then get the error message appearing which will point out on which line the error has occured and at which character, alternatively if you have Oracle procedure builder run the query in there and use the built in de bugging editor.
All of the Oracle software can be downloaded for free to be used for evaluation etc.
Also why not post this query to Oracle themselves.
Some fields must be named. I think the following have problem "...Sum(b.ACT_REG_COST) as T_Act_Reg_Cost, Sum(b.ACT_THIS_PER_COST) as T_Act_This_Per_Cost, Sum(b.REMAIN_COST) as T_Remain_Cost, Sum(b.TARGET_COST) as T_Target_Cost..."
Give a name to these columns.
Field: X: sum(b.ACT_REG_COST)
Table: BLANK
Total: Expression
Criterial: BLANK
If you want to add selection criterial, add one more column with Total is "where" and in hidden mode.
Member for
16 years 9 monthsRE: MS Query and Oracle
Try running this script at the Oracle SQL prompt
SQL > Create view tal_contractor_rsrc as
SELECT etc etc....
you will then get the error message appearing which will point out on which line the error has occured and at which character, alternatively if you have Oracle procedure builder run the query in there and use the built in de bugging editor.
All of the Oracle software can be downloaded for free to be used for evaluation etc.
Also why not post this query to Oracle themselves.
Member for
23 years 8 monthsRE: MS Query and Oracle
Some fields must be named. I think the following have problem "...Sum(b.ACT_REG_COST) as T_Act_Reg_Cost, Sum(b.ACT_THIS_PER_COST) as T_Act_This_Per_Cost, Sum(b.REMAIN_COST) as T_Remain_Cost, Sum(b.TARGET_COST) as T_Target_Cost..."
Give a name to these columns.
Field: X: sum(b.ACT_REG_COST)
Table: BLANK
Total: Expression
Criterial: BLANK
If you want to add selection criterial, add one more column with Total is "where" and in hidden mode.