DIFFERENCES

Oracle database related all differences

SQL

---

• LONG Vs LOB Data Type 
• Truncate Vs Delete
• Case Vs Decode
• Relational Table Vs Nested Table
• SYS_REFCURSOR Vs REF CURSOR
• Primary Key Vs Foreign Key
• Rank Vs Dense Rank Vs Rownum
• Rownum Vs Row_number
• Join Vs Union
• Where Vs Having

PL/SQL 

---

• Collection Vs Record
• Associative Array(Index by Table) Vs Nested Table Vs Varrays
•