right parenthesis error message

ba_trainer
ba_trainer used Ask the Experts™
on
for oracle.
getting error message mising right parenthesis..trying to create view.
Can anyone help? Thanks!
Beth
CREATE VIEW OVERTIME_COSTS (TRANSACTION_CODE, SUM(JOBCOSTS_UNITS * COST_PER_UNIT) AS "TOTAL COST")
AS
SELECT TRANSACTION_CODE, JOBCOST_UNITS, COST_PER_UNIT
FROM JOBCOST
WHERE TRANSACTION_CODE = 'O'
GROUP BY TRANSACTION_CODE
;

Open in new window

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Database Consultant
Top Expert 2009
Commented:
CREATE VIEW OVERTIME_COSTS (TRANSACTION_CODE,  "TOTAL COST")
AS
SELECT TRANSACTION_CODE,  SUM(JOBCOSTS_UNITS * COST_PER_UNIT)
FROM JOBCOST
WHERE TRANSACTION_CODE = 'O'
GROUP BY TRANSACTION_CODE
;
Top Expert 2009

Commented:
CREATE VIEW OVERTIME_COSTS (TRANSACTION_CODE, "TOTAL COST")
AS
SELECT TRANSACTION_CODE, SUM(JOBCOSTS_UNITS * COST_PER_UNIT) AS "TOTAL COST", COST_PER_UNIT
FROM JOBCOST
WHERE TRANSACTION_CODE = 'O'
GROUP BY TRANSACTION_CODE
;
Top Expert 2009

Commented:
Or aneesh' answer should work too on Oracle just fine.

Author

Commented:
THANKS! Beth

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial