Differences in Oracle

OLAP    vs   OLTP	RANK   vs   Dense_Rank	Sysdate   vs  Timestamp	Substr   vs   Instr	ER Model   vs   RDBMS
&    vs    &&	Union  vs   Union ALL	Decode   vs    Coalesce	Alter     vs    Update	Replace   vs   Translate
NVL       vs    NVL2	Distinct   vs   Distinct ALL	Where   vs   Having	Mod      vs    Remainder	DML    vs     DDL
Months_between vs    Add_months	Column Constraints   vs     Table Constraints	Unique     vs                      Primary Key	Composite Key    vs      Primary Key	DBTimeZone vs SessionTimeZone
Primary Key    vs                 Cadidate Key	Primary Key    vs                                 Alternate Key	CurrentTimeStamp                 vs   SysTimeStamp   vs LocalTimeStamp	Drop    vs Delete   vs    Truncate	Foreign Key       vs Self Referential Integrity