Orneklerle Java ve PLSQL

SELECT 'INSERT INTO CF_LOV_RELATION (RELATION_TYPE, LOV_ID, PARENT_LOV_ID, IS_DEFAULT, CDATE, UDATE) VALUES (' 
|| CF_LOV_RELATION.RELATION_TYPE || ',' || CF_LOV_RELATION.LOV_ID ||','|| CF_LOV_RELATION.PARENT_LOV_ID || ','
|| nvl(CF_LOV_RELATION.IS_DEFAULT,'NULL') || ','|| CF_LOV_RELATION.CDATE ||','|| nvl(to_char(CF_LOV_RELATION.UDATE,'dd/mm/yyyy'),'NULL') ||')' 
AS InsertStatement FROM CF_LOV_RELATION where rownum < 3;

SELECT 'INSERT INTO CF_LOV_RELATION (RELATION_TYPE, LOV_ID, PARENT_LOV_ID, IS_DEFAULT, CDATE, UDATE) VALUES (' || CF_LOV_RELATION.RELATION_TYPE || ',' || CF_LOV_RELATION.LOV_ID ||','|| CF_LOV_RELATION.PARENT_LOV_ID || ',' || nvl(CF_LOV_RELATION.IS_DEFAULT,'NULL') || ','|| 'TO_DATE('||'''' ||CF_LOV_RELATION.CDATE || '''' ||', ''MM.DD.YYYY HH24:MI:SS'')' ||','|| 'SYSDATE'||')' AS InsertStatement FROM CF_LOV_RELATION where relation_type = 'PARENT_CHILD_BAYITIPI' and rownum < 3; SELECT 'INSERT INTO CF_LOV_RELATION (RELATION_TYPE, LOV_ID, PARENT_LOV_ID, IS_DEFAULT, CDATE, UDATE) VALUES (' || CF_LOV_RELATION.RELATION_TYPE || ',' || CF_LOV_RELATION.LOV_ID ||','|| CF_LOV_RELATION.PARENT_LOV_ID || ',' || nvl(CF_LOV_RELATION.IS_DEFAULT,'NULL') || ','|| CF_LOV_RELATION.CDATE ||','|| nvl(to_char(CF_LOV_RELATION.UDATE,'dd/mm/yyyy'),'NULL') ||')' AS InsertStatement FROM CF_LOV_RELATION where rownum < 3;