Thursday, February 2, 2017

Table column cir_no varchar2(2)


select  to_char(NVL(MAX(cir_no),0)+ 1) into :cir_no from cir_info; 
----
select  to_number(NVL(MAX(cir_no),0)+ 1) into :cir_no from cir_info; 


No comments:

Post a Comment

How to install and configure Oracle Apex 24.1 with ORDS 22, Tomcat 9 and Jasper Report 7 on Oracle Linux 8.10

#########################Install Oracle  APEX 24.1################################ ----------------------------------------------------...