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”
Sending emails using an APEX application- part 1
This article summaries the steps taken to configure APEX application to send emails. We shall use the email delivery service from Oracle Cloud. New to Oracle cloud? Get a free trial version of Oracle cloud here. The assumption is that you have already configured your IAM policies correctly ie. the user we use is in … Continue reading “Sending emails using an APEX application- part 1”
Loading…
Something went wrong. Please refresh the page and/or try again.
Get new content delivered directly to your inbox.
The Cloud Adoption Blog 