Home -> Usenet -> comp.databases.oracle -> sql statement required to produce a statement

sql statement required to produce a statement

From: Louis Dumont <dumontls_at_dumontls.com>
Date: Fri, 12 Apr 2002 16:29:15 GMT
Message-ID: <vXDt8.24980$vc3.89415_at_news-server.bigpond.net.au> 






The following sql statement required to produce a statement
BROWN a CLERK worked 20 hours in DRAWING 5 on 11 March 2020




ERROR:



ORA-01756: quoted string not properly terminated



SELECT (N.PERS_NAME || 'a" || P.POSN_NAME || 'worked' || MAX(A.ACTIV_HOURS)
|| 'hours on' fmFormat(A.ACTIV_DATE, 'DD-Month-YYYY'))
FROM POSITION P,PERSONNEL N, ACTIVITY A, UNIT U

WHERE P.POSN_ID=N.POSN_ID



AND N.PERS_ID=A.PERS_ID



AND A.UNIT_ID=U.UNIT_ID


can some one tell mewhat im doing wrong




(the angry face is actually and x and a ( which cause the angry face)
Received on Fri Apr 12 2002 - 18:29:15 CEST












Original text of this message