Demos

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.

%d bloggers like this: