All topics
Database · Learning hub

Oracle Database cheat sheet & developer notes

Oracle Database cheat sheet and 3 curated developer notes — core concepts, patterns, and interview prep. Maintained by the DevRecall team.

Save this stack to your DevRecallTest yourself — Oracle Database quizMore Database notes
01 · Oracle Database

SQL & PL/SQL Fundamentals

Oracle Database: SQL & PL/SQL Fundamentals. Oracle Database is a relational database management system with a rich SQL dialect and PL/SQL — a procedural extension of SQL for writing stored procedures, functions, triggers…

Read
02 · Oracle Database

Performance: Indexing, Query Plans & Hints

Oracle Database: Performance Tuning. Indexes. -- B-tree index (default) CREATE INDEX idx_emp_dept ON employees(department_id); CREATE INDEX idx_emp_name ON employees(last_name, first_name); -- composite -- Unique index C…

Read
03 · Oracle Database

Administration: Users, Tablespaces & Backup

Oracle Database: Administration. Users & Privileges. -- Create user CREATE USER myapp IDENTIFIED BY "SecurePass123" DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp QUOTA 500M ON users; -- Grant privileges GRANT CONNEC…

Read

Related stacks

CassandraCockroachDBCouchDBDrizzleDrizzle ORMDynamoDBElastiCacheElasticsearchEventStoreInfluxDBMariaDBMemcached
Browse all stacks →

Keep your Oracle Database knowledge sharp.

Save this stack to your personal DevRecall — add your own notes, track what you're learning, and share what you know with the community.

Get started — free forever