x

Why keeps showing this error

CREATE OR REPLACE FORCE EDITIONABLE VIEW "VU_REPORT7" ("Selling Report") AS SELECT a2.FIRST_NAME || a2.SUR_NAME ||', living in '||a4.COUNTRY||', '||a4.CITY||' '||a4.LINE_1||a4.LINE_2||a4.LINE_3||a4.LINE_4||', bought an '|| a1.MAKE ||' '|| a1.MODEL ||' from employee '|| a3.FIRST_NAME ||' '|| a3.SUR_NAME ||' at '|| a1.SOLD_DATE ||', Making a profit of ' || to_char(a1.SOLD_PRICE - a1.PURCHASE_PRICE) ||' pounds.' AS "Selling Report", a1.SOLD_DATE || (SELECT SUM(a5.SOLD_PRICE)-SUM(a5.PURCHASE_PRICE) FROM a5 WHERE a5.SOLD_DATE <= a1.SOLD_DATE) AS "OVERALL"

FROM CAR a1, CUSTOMER a2, staff a3, ADDRESS a4,(SELECT * FROM CAR ORDER BY SOLD_DATE) a5

WHERE a1.BOUGHT_BY_CUSTOMER_NO = a2.CUSTOMER_NO and a1.SOLD_BY_STAFF_NO = a3.STAFF_NO and a4.ADDRESS_NO = a2.ADDRESS_NO

ORDER BY a1.SOLD_DATE

shows error: ORA-24344: success with compilation error

more ▼

asked May 14, 2016 at 11:15 AM in Default

avatar image

gyn
1

(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1205
x442

asked: May 14, 2016 at 11:15 AM

Seen: 59 times

Last Updated: May 15, 2016 at 03:08 AM

Copyright 2018 Redgate Software. Privacy Policy