Some AutoGen Code Formats

/* Formatted on 2012/07/12 15:50 (Formatter Plus v4.8.8) */
CREATE OR REPLACE FUNCTION supply_formate(colname varchar)
   RETURN VARCHAR2
IS v_autocode    VARCHAR (50);
   v_query   VARCHAR2 (4000);
BEGIN
   v_query :='select ''sup/''||TO_CHAR (SYSDATE, ''YY'')||''-''||(select TO_CHAR (SYSDATE, ''YY'')+1 FROM DUAL) ||''/''||(SELECT NVL (MAX ('||colname||'), 0)+1  FROM supply_multiple_employee ) from dual';
   dbms_output.put_line('v_query33 :'||v_query);
   EXECUTE IMMEDIATE v_query
                INTO v_autocode;

   RETURN v_autocode;
END;
/


select supply_formate() from dual

SELECT  'SUP/'||TO_CHAR (SYSDATE, 'YY')'-'(SELECT TO_CHAR (SYSDATE, 'YY') + 1 FROM DUAL)/(SELECT NVL (MAX (ID), 0) + 1  FROM supply_multiple_employee) fromate from dual from dual


select 'sup/'||TO_CHAR (SYSDATE, 'YY')||'-' from dual

select 'sup/'||TO_CHAR (SYSDATE, 'YY')||'-'||(select TO_CHAR (SYSDATE, 'YY')+1 FROM DUAL)suplformat from dual

select 'sup/'||TO_CHAR (SYSDATE, 'YY')||'-'||(select TO_CHAR (SYSDATE, 'YY')+1 FROM DUAL) ||'/'||(SELECT NVL (MAX (ID), 0)+1  FROM supply_multiple_employee ) from dual
select 'sup/'||TO_CHAR (SYSDATE, 'YY')||'-'||(select TO_CHAR (SYSDATE, 'YY')+1 FROM DUAL) ||'/'||(SELECT NVL (MAX (ID), 0)+1  FROM supply_multiple_employee ) from dual

select supply_formate('id')autocode from dual