Oracle SQL Programming
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.
SQL data loading patterns ↓
These blog posts show you how to work SQL*Loader, Oracle Data Pump, an external tables.
SQL joins, subqueries, statements, and normalization ↓
These blog posts show you how to work with SQL to solve problems in a database.
SQL language functions ↓
These blog posts show you how specific functions in an Oracle database.
SQL Large Objects (LOBs) ↓
These blog posts show you how to work with large objects in an Oracle database.
SQL operators ↓
These blog posts show you how to work specialized SQL operators in various databases.
SQL techniques ↓
These blog posts show you how to work with quirks or special characteristics of databases.
If you have suggestions of additional topics, let me know by posting a comment.
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