TechOnTheNet
FreeComprehensive Oracle & PL/SQL Tutorial
FreeFree tier
About TechOnTheNet
TechOnTheNet offers a comprehensive Oracle tutorial covering both Oracle and PL/SQL. The tutorial starts with the basics of retrieving and manipulating data, then progresses to advanced topics such as creating tables, functions, procedures, triggers, tablespaces, schemas, and Oracle-specific functions. It includes detailed sections on SQL clauses, joins, subqueries, error messages, system tables, database administration, and programming constructs like cursors, variables, exception handling, and loops. The resource is free and requires no prerequisites, making it suitable for beginners and experienced users alike.
Key Features
Covers Oracle and PL/SQL from basics to advanced topics
Topics include data manipulation, tables, functions, procedures, triggers, tablespaces, and schemas
Detailed reference for SQL clauses, joins, subqueries, and set operators
Database administration guides on tablespaces, users, schemas, privileges, and roles
Programming sections with cursors, variables, exception handling, loops, and transactions
Oracle error message explanations and system table descriptions
Pros & Cons
Pros
- Free and accessible without account or payment
- No prerequisites required – suitable for absolute beginners
- Covers a wide range of Oracle topics from SQL to advanced database administration
- Structured progression from basic to advanced concepts
- Includes practical references for functions, error messages, and system tables
Cons
- Text-only content with no interactive exercises or code execution environment
- May not cover the very latest Oracle versions or features
- Site design is basic and not mobile-optimized
- Limited to Oracle/PLSQL; no coverage of other database systems
Best For
Learning Oracle and PL/SQL from scratchReference for Oracle SQL syntax, functions, and database administrationPreparing for Oracle database certification or job interviewsTroubleshooting Oracle errors using the error message referenceUnderstanding Oracle programming constructs for stored procedures and triggers
FAQ
What is Oracle?
Oracle is a relational database technology developed by Oracle Corporation.
What is PL/SQL?
PL/SQL stands for Procedural Language extensions to SQL and is an extension of SQL used in Oracle, adding programming constructs not native to SQL.
Are there any prerequisites for this Oracle tutorial?
No, there are no prerequisites for this Oracle tutorial. You can learn the basic concepts and progress to more advanced topics.
What topics are covered in the tutorial?
The tutorial covers data retrieval and manipulation, creating tables, functions, procedures, triggers, tablespaces, schemas, Oracle-specific functions, SQL clauses, joins, subqueries, error messages, system tables, database administration, and programming constructs like cursors, variables, exception handling, loops, and transactions.