
The future of Low code application development platforms
According to Gartner, by 2023, over 50% of medium and large enterprises will have adopted low code application development platforms (LCADP) as one of their application development strategies. Currently the non-tech companies are becoming digitized at such a fascinating rate, thus a need to develop applications faster to improve on their inefficiencies and keep ahead … Continue reading “The future of Low code application development platforms”
Set Default Date on APEX form using SQL Query
Go to the form and edit the default value of date item; Set type SQL Query; SELECTCURRENT_DATEFROMDUAL;
Oracle Date Function; ADD_MONTHS
This adds months to the current date; ie. SELECT ADD_MONTHS( DATE ‘2016-02-29’, 1 ) FROM dual; Reference: Oracle Tutorial.com
Oracle Identity Column
An Identity column auto increments on input, introduced from Oracle 12C, it’s a useful for the surrogate primary key column. Syntax: GENERATED [ ALWAYS | BY DEFAULT [ ON NULL ] ] AS IDENTITY [ ( identity_options ) ] create table FAQS(id number(10) GENERATED ALWAYS AS IDENTITY START WITH 1, faq varchar (1000)); // add … Continue reading “Oracle Identity Column”
Loading…
Something went wrong. Please refresh the page and/or try again.
Get new content delivered directly to your inbox.