Show Menu
Cheatography
  1. Home >
  2. Programming >

Oracle Cheat Sheet (DRAFT) by

Basic Commands Oracle

This is a draft cheat sheet. It is a work in progress and is not finished yet.

BASIC COMMANDS

SELECT
INSERT
UPDATE
DELETE
 

Date Functions

"­add­_­m­onths (d, n)"
Date d plus n months
"­mon­t­h­s_­­between (d, e)"
Months between dates d and e (d-e)
last_day (d)
Last day of the month containing date d
"­nex­t_day (d, weekda­y)"
"­new­_time (d, z1, z2)"
"­round (d[, fmt])"
"­trunc (d[, fmt])"
"­extract (c from d)"
 

Functions