All topics
Database · Learning hub

Oracle Database notes for developers

Master Oracle Database with a curated set of 3 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 CRE…

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 CONNECT,…

Read

Related stacks

CassandraDrizzleDynamoDBMariaDBMemcachedMongoDBMySQLPostgreSQLPrismaRedisSQL ServerSQLite
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