Hi, Check this... url:{concat('${OA_MEDIA}','/logo.gif')}

Hi, Have you checked in preview excel or by application you ran the program and view output?

Yes, That's why I have asked him.

Hi, It's not clear. As per my understanding, if there are two queries, you want to use first query column in second query. Right? Then yes, bind variable is correct. You can use like :First_col_column Hope this will help you...

Hi, Just check this... it may help you... SELECT SUBSTR(COL2,1,6), COL2, SUBSTR(COL2,8,9) FROM TEST2 where substr(col2,1,6) not in (select substr(col2,1,6) from test2 where substr(col2,8,9)='99') ; replace your table and your column in above select statement

Hi, Not clear. You want to remove 910620-00, but you need 910035-00. So how? based on which scenario you need second? Always better to provide table creation and insert scripts and required output for quick solutions...

Hi, Re: 2. How do I ask a question on the forums?