KP automatically create by LPAD /RPAD

varcahr2(30)

SELECT NVL(MAX(TO_NUMBER(ISSUE_NO)),0)+1 into :br_issue_master.ISSUE_NO from br_issue_master;




SQL> create table TTT
(col varchar2(30));


SQL> select  LPAD(NVL(MAX(TO_NUMBER(col))+1,0),6,'0')+1  ggggggggggggggggg from TTT;

---number wise insert
GGGGGGGGGGGGGGGGG
-----------------
                1

SQL>  select   'QQQ'|| LPAD(NVL(MAX(TO_NUMBER(col))+1,0),6,'0')  ggggggggggggggggg from TTT;
 ---varcahr2 wise insert

GGGGGGGGG
---------
QQQ000000
====================================================

create table TTT (col number(30));


SQL> select   LPAD(NVL(max(to_number(col)),0),6,'0')+1 from TTT;

LPAD(NVL(MAX(TO_NUMBER(CAL)),0),6,'0')+1
----------------------------------------
                                       1


SQL> select   LPAD(NVL(max(to_char(cal)),0),6,'0')+1 from RRR;

LPAD(NVL(MAX(TO_CHAR(CAL)),0),6,'0')+1
--------------------------------------
                                     1