Md. Quium Hossain who I'm Oracle DBA & APEX Developer. All-rounder in building small, medium, and enterprise applications. Extensive knowledge in various areas of web-driven applications in Back-end (PL/SQL, SQL, Java), Front-end (Oracle APEX, Oracle Forms, Oracle Reports, HTML, JavaScript, CSS, jQuery, OracleJET, ReactJS), RESTful APIs, Third-party library integrations (Apex Office Print (AOP), Payment Gateways, SMS, Syncfusion, HighCharts) and APEX Plugins (HighChart, StarRating)
Friday, February 24, 2017
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
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...
-
# Report Column (only column): 1. Column Formatting > HTML Expression <span style="display:block; width: 200px"> #...
-
Installing Oracle Forms and Reports 12c on Windows 10 64 Bit. Hardware used for this installation is · Intel i3-2370M CPU · ...
-
when open forms builder then errors FRM-91129: fatal error: no value specified for required environment variable FORMS_BUILDER_CLASSPATH a...
-
---------------------------- | Keyboard Shortcut | ---------------------------- · Create: Breadcrumb Region Ctrl+/, C, B · ...
No comments:
Post a Comment