How do you include static text in select statement in Dynamic pl/sql

I want to include some atatic text and get the output of 4 columns joined with a ":" delimiter within them in a select statement built using Dynamic PL/SQL. How do I build it.

e.g.

Normal select statement would be

select 'MY SKU IS : ', col1||':'||col2||':'||col3||':'||col4 from table1 where ...where condition

and output looks like :

MY SKU IS A:B:C:D

MY SKU IS a:b:c:d

...

Dynamically I have -

SQL_Stmt := 'select 'MY SKU IS : ', col1||':'||col2||':'||col3||':'||col4 from table1 where '|| wherecondition;

I understand that this does not work because the single quote terminates the string. But my question is how do I achieve the same result with dynamic PL/SQL ? How do I include the static strings and the delimiters. I have tried using double quote, '\'...

??

http://oracle.itags.org/q_oracle_98035.html