MacLochlainns Weblog

Michael McLaughlin's Technical Blog

Site Admin

Oracle SQL Programming

with 3 comments

This links to my blog posts and pages dealing with Oracle SQL programming. They include SQL programming solutions, concept examples, techniques, and user defined types. The blog pages show below the top-level page in the right hand column, while blog posts only show in the list below.

Creating specialized views ↓

These blog posts show you how to explore the Oracle database’s data dictionary.

Learn how you create a view of external files that are defined in an Oracle database.

Learn how you create a view of all schema tables and views that mimics a DESCRIBE for all objects.

Learn how you create a view of all user defined collection data types.

Learn how to query the data dictionary to find key and reserved words.

Hierarchical queries ↓

These blog posts show you how to work with hierarchies or trees in the Oracle database.

Learn how to use hierarchical queries in an Oracle database.

SQL data loading patterns ↓

These blog posts show you how to work SQL*Loader, Oracle Data Pump, an external tables.

Learn how you create external tables that use Oracle Data Pump.

Learn how you create external tables that use SQL*Loader.

Learn how you convert and upload XML data through external tables into Oracle.

SQL joins, subqueries, statements, and normalization ↓

These blog posts show you how to work with SQL to solve problems in a database.

Learn how you use the basic SQL joins.

Learn how a basic SQL query works.

Learn how you normalize your data model and why you do it.

SQL language functions ↓

These blog posts show you how specific functions in an Oracle database.

Learn how you use the CONCAT function, and compare it against MySQL and SQL Server.

Learn how you assign a dynamic INTERVAL YEAR TO MONTH data types.

Learn how you use the TO_YMINTERVAL function, and the leap year limits.

Learn how you use the ADD_MONTHS function with month ending dates.

Learn how you use the NUMTODSINTERVAL function.

SQL Large Objects (LOBs) ↓

These blog posts show you how to work with large objects in an Oracle database.

Learn about Oracle LOB Features.

Learn how you cleanup wasted LOB space.

Learn how you match LOBs to their respective LOB indexes.

SQL operators ↓

These blog posts show you how to work specialized SQL operators in various databases.

Learn how you use the IS OF operator for object type comparisons.

SQL techniques ↓

These blog posts show you how to work with quirks or special characteristics of databases.

Learn how you join nested tables results to other table elements.

Learn how you use a natural join, the ups, downs, and whoa that’s not what’s wanted.

Learn how you use inline views, table fabrication, and the WITH clause.

Learn how you validate foreign key column constraints.

If you have suggestions of additional topics, let me know by posting a comment.

Written by maclochlainn

November 13th, 2008 at 12:33 am

Posted in Uncategorized

3 Responses to 'Oracle SQL Programming'

Subscribe to comments with RSS or TrackBack to 'Oracle SQL Programming'.

  1. Is there a limit on the number of rows a query may return in Oracle? is 3,000,000,000 to many?

    jbain

    14 May 10 at 4:37 pm

  2. I had these errors thrown for this entry

    SQL> SET sqlprompt "'SQL:'_user at _connect_identifier>"
SP2-0734: unknown command beginning " SET sqlpr..." - rest of line ignored.
SP2-0044: For a list of known commands enter HELP
and to leave enter EXIT.

    Brandon Hawkes

    20 Sep 12 at 12:49 pm

  3. Thanks for providing these useful topics. It makes searching topics regarding to SQL and Oracle much easier.
    Thanks for that.

    Oracle Datenbanken

    4 Mar 13 at 4:18 am

Leave a Reply