quotes!

[Thiko]

can someone tell me where to remove the quotes on this select to remove the last quote from the result???

I just can't see it!

SELECT 'host exp80 '||var1||'/'||var2||'@ora.comp789 FILE=exp_'||var1||'_'||TO_CHAR(sysdate,'dd-mm-yyyy_HH24:MI:SS')||'_seq'||ExportDumpID.NEXTVAL
||'.dmp GRANTS=Y ROWS=Y LOG=dump.log'''
FROM jobrequest
WHERE id = 121;


RESULT:

host exp80 suint/suint@ora.comp789 FILE=exp_suint_24-07-2001_11:20:19_seq280.dmp GRANTS=Y ROWS=Y LOG=dump.log' Many Thanks.

Thiko!

 

[karluk]

You have to remove two of the three consecutive quotes near the end. It should be LOG=dump.log' instead of LOG=dump.log'''.

 

[Thiko]

thanks!! Many Thanks.

Thiko!