Re: sql statement required to produce a statement

You have a double quote after a. It should be a single quote.

John

"Louis Dumont" <dumontls_at_dumontls.com> wrote in message news: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 - 20:53:29 CEST