Keywords

Keywords have a special meaning in the Oracle database, and a specific role to play in the context they appear. FUNCTION, MAX, COMMIT are some examples of Oracle keywords.

Thumbnail image for The Difference Between DECODE and CASE

The Difference Between DECODE and CASE

Both DECODE and CASE statements in Oracle are used for IF-THEN-ELSE conditional operations, but there are distinct differences in their power and behavior.

Read the Full Article →
Thumbnail image for Hierarchical Queries: A QuickStart Guide

Hierarchical Queries: A QuickStart Guide

A hierarchical query is one that works on data with a tree relationship. Oracle provides specialized keywords that work with hierarchical queries, such as START WITH…CONNECT BY, PRIOR and SYS_CONNECT_BY_PATH.

Read the Full Article →
Thumbnail image for The Difference between DELETE, TRUNCATE and DROP

The Difference between DELETE, TRUNCATE and DROP

DELETE, TRUNCATE and DROP – all three commands get rid of table data. How exactly are they different? When should you use which?

Read the Full Article →
Page 3 of 3
1
2
3