MS Query and Oracle
Forum Sponsor
Top Posters
bal aji
2 posts
Lee Mallek
23 posts
Syed Shoeb
0 posts
Viet Tran
8 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
James Williams
74 posts
Haque Nawaz
10 posts
EViLL1
1 posts
Dimitrios Theocharidis
3 posts
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.