MS Query and Oracle
Featured Partner
Top Posters
xerxes
0 posts
edwin
0 posts
jhalluk69
0 posts
wilmoahyi
0 posts
Peter Holroyd
51 posts
Robert Guers
1 posts
Jerry Robinson
2 posts
James Williams
75 posts
Elyar Safarov
1 posts
Christopher Ganotice
1 posts
Our Partners
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.
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.