Oracle tutorials
Oracle Database Tutorials
Every Oracle Database tutorial on DatabaseFAQs.com, grouped by topic: installation, users, tables, every built-in datatype, and date formatting.
The datatype section covers each Oracle type on its own page, with examples.
- 64free Oracle tutorials
- 10topics
- Oct 2026last updated
New to Oracle? Start here
Read these in order. Each one builds on the one before it.
- Oracle 19c installation on Windows 10 + Video TutorialInstall Oracle Database on Windows.
- Connect to oracle databaseConnect with SQL*Plus or SQL Developer.
- Oracle Create User – Detailed GuideCreate a user and grant privileges.
- How to create table in OracleCreate your first table.
- Oracle Database DatatypeLearn the datatypes you'll use daily.
- Oracle to_date Format [Complete Guide]Convert text to dates and back.
Install, connect and tools8
Install it, connect to it, and get your tools working.
- Connect Excel to Oracle Database
- How to Check Oracle Database Version
- How To connect To Oracle Database Using Python
- How to Fetch Data from Oracle Database in Python
- How to Install Oracle on Docker
- Oracle Install sample schemas 21c
- Connect to oracle database
- Oracle 19c installation on Windows 10 + Video Tutorial
Databases, tables and columns16
Create and change databases, tables, columns, keys, indexes and views.
- Alter Table Add Column Oracle
- How To Check Oracle Database Read Write Mode
- How to create a database in Oracle 19c
- How to Get List all Tables in Oracle Database
- Oracle Add Foreign Key
- Oracle add primary key
- Oracle Add Row Number
- Oracle Change Database Name
- Oracle check database status
- Oracle Create Index – Detailed Guide
- Oracle Create Sequence Tutorial
- Oracle Drop Database
- Oracle get database name
- Oracle how to copy a table
- Oracle stored procedure create table
- How to create table in Oracle
Data types29
Pick the right data type for every column.
- Char Datatype in Oracle Database
- Clob Datatype in Oracle Database
- Dec Datatype in Oracle Database
- Decimal Datatype in Oracle Database
- Float Datatype in Oracle Database
- Nchar Datatype in Oracle Database
- Number Datatype in Oracle
- NVARCHAR2 in Oracle Example
- Oracle Binary_double Datatype
- Oracle Binary_float Datatype
- Oracle Blob Datatype
- Oracle Datetime Datatype
- Oracle Double Precision Datatype
- Oracle interval day Datatype
- Oracle Interval_year datatype
- Oracle Long Datatype
- Oracle nclob Datatype
- Oracle numeric Datatype
- Oracle rowid Datatype
- Oracle Sdo_Geometery Datatype
- Oracle SDO_TOPO_GEOMETRY Datatype
- Oracle Smallint Datatype
- Oracle urowid Datatype
- Oracle Varchar2 Datatype
- Oracle XML Datatype
- Oracle Year Data type
- Real Datatype Oracle
- Time Datatype in Oracle Database
- Oracle Database Datatype
SELECT queries, filtering and grouping1
Read data with SELECT, filter it, sort it and summarize it.
Insert, update and delete1
Add, change and remove rows safely.
Dates and times3
Format, compare and calculate dates and times.
Stored procedures, variables and control flow1
Stored procedures, variables, IF/CASE logic, loops, error handling and transactions.
Users, logins and permissions1
Create users, reset passwords and grant the right permissions.
Backup, import/export and administration3
Back up, restore, import, export, migrate and monitor.
Comparisons1
Side-by-side comparisons to help you choose.
Other database tutorials
Looking for everything, newest first? See the full tutorial list.
Frequently Asked Questions
Is there a free version of Oracle Database?
Yes. Oracle Database Free is a no-cost edition for learning and small apps. It has limits on CPU, memory and data size, so check Oracle’s site for the current numbers.
Where should a beginner start?
Install Oracle, connect to it, create a user and a table, then read the datatypes overview. That’s the path at the top of this page.
How do I format dates in Oracle?
Use TO_CHAR to turn a DATE into text in the format you want, and TO_DATE to turn text into a DATE. Both tutorials are linked in the Dates section.