Oracle DBA Lesson 22 Part 1 — Startup Stages and File Dependencies

Oracle startup is a sequence of dependencies. Each completed stage tells you what Oracle has successfully established and what informat...

Read the full lesson

Oracle DBA Lesson 21 Part 5 — Why Dates and Numbers Look Different

A date or number has a value. Displaying it requires text. Two Oracle sessions can apply different conversion rules to the same value a...

Read the full lesson

Oracle DBA Lesson 21 Part 4 — Why Text Looks Wrong in SQL*Plus

The same database text can look different in two clients. A useful first question is whether the character bytes are being interpreted ...

Read the full lesson

Oracle DBA Lesson 21 Part 3 — Characters, Bytes, and VARCHAR2 Column Limits

A text value can contain fewer characters than bytes. That difference matters when a column limit is measured in bytes. This lesson sho...

Read the full lesson

Oracle DBA Lesson 21C — Characters, Bytes, and Text-Column Limits

SQL Developer is another client for the same PDB you already open with SQL*Plus. This lesson connects to LABPDB as COURSE_READER , co...

Read the full lesson