This is where you will find SQL code examples and snippets for Oracle 10g, Oracle 9i and Oracle 8i. Our examples are based upon our training manager database which you can download from here. You can also download the data to load into the database as well.

Course Registration Database

SQL DML	String Functions	Stored Procedures
Select Update Insert Delete	Substring function Upper and Lower functions LTRIM and RTRIM functions	Select stored procedure Update stored procedure Insert stored procedure Delete stored procedure
SQL VIEWS	Table Basics
SQL Views - Basics	Create SQL Table Foreign Key Constraint Data Types Add / Alter Column Drop Table

SQL Server Information and Resources Bookmark this page

SQLINFO.net is a Community Service from DataExpressions makers of dbOrchestra©

Oracle Code Examples

Oracle SQL Code Examples

SQL DML

String Functions

Stored Procedures

SQL VIEWS

Table Basics