SQL & PL/SQL

For this below query I want single quotes are required for each kintana_number

and when I increase value <=100 I get error like ORA-19011 how to modify above one get in single quotes and avoid 0ra-19011
please help

SELECT DISTINCT RTRIM
(XMLAGG
(XMLELEMENT (e, p.kintana_number || ',').EXTRACT
('//text()')
),
','
)
FROM project p where p.projectid <=100


select
listagg (kintana_number, ',')||''''
WITHIN GROUP
(ORDER BY kintana_number)
FROM
project where projectid<=100
I want every kintana_number should be in singlequote after every comma separated

Edited by: user13301356 on Feb 8, 2013 12:39 AM