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; 


By at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

To generate a PDF using JavaScript in Oracle APEX from a collection

  To generate a PDF using JavaScript in Oracle APEX from a collection, you can follow these steps: 1. Create a button or link on your APEX p...