Relational database
The long-standing heavyweight of enterprise data.
A multi-model enterprise database with PL/SQL, Real Application Clusters (RAC), partitioning, Data Guard and extensive features for mission-critical workloads.
Oracle DatabaseIntermediateYour long query needed undo that was already overwritten. How Oracle read consistency uses undo, how to read V$UNDOSTAT, and why committing inside a loop causes it.
#configuration#mvcc#troubleshooting
Oracle DatabaseIntermediateIn this article, we will see what the newly launched Eighth Generation of Oracle SPARC platform has to offer.
Oracle DatabaseBeginnerCreate, find, drop, disable and enable primary keys in Oracle, including composite keys, identity columns, the index behind the constraint and the ORA errors you will hit.
Oracle DatabaseBeginnerChoose the right Oracle data type for text, numbers, dates, LOBs, JSON, BOOLEAN and VECTOR columns, with size limits and the conversion and NULL behaviour that causes bugs.
Oracle DatabaseBeginnerLearn what Oracle's DUAL table is, when you still need FROM DUAL now that it is optional in 23ai and later, how to generate rows from it, and the mistakes to avoid.
Oracle DatabaseBeginnerCreate an Oracle database the current way: build a container database with DBCA, add pluggable databases with CREATE PLUGGABLE DATABASE, then verify, connect and drop them.
#windows-10
Oracle DatabaseBeginnerUnderstand what Oracle OLAP cubes are, why the option is deprecated, how to check whether your database uses it, and how to build the same model with analytic views.
Oracle DatabaseBeginnerWrite your first PL/SQL blocks, procedures and functions in Oracle, handle exceptions and query results correctly, and avoid the mistakes that make PL/SQL slow or unsafe.
#pl/sql
Oracle DatabaseBeginnerLearn how Oracle Database is put together: instances, memory, files, tablespaces, schemas and pluggable databases, plus editions and a quick way to start a practice database.
