Foreign Key Constraints Revisited
:
Full/partial schema refreshes across environments are a regular requirement in databases. This article builds on a previous article, providing scripts to disable and re-enable foreign key constraints on all of the tables in a schema.
Multilingual linguistic searching and sorting in Oracle
:
How well do you know the sorting rules of your own language? Chances are, Oracle knows them much better than you, in addition to knowing all the rules for all of the languages Oracle supports. Take a tour through Oracle's multilingual linguistic searching and sorting features.
Sorting Strings in Oracle
:
Learn what Oracle has to offer with respect to searching and sorting, and especially so when it comes to linguistic sorting. You may not know this, but you do have some
control over how sorts are performed within your database's character set and you can compare Apples to apples, as it turns out.
Searching and Sorting Strings in Oracle
:
Steve Callan discusses what takes place inside the Oracle database when you're searching for something "LIKE" the value of interest. How does Oracle approach the problem of determining if the string 'ABCD' appears in the string 'ABCABDABCDAB' and if it does, how many times?
DBA Insider - Useful PL/SQL Packages
:
Oracle supplies quite a large complement of pl/sql stored procedures, packages, and functions, which can help with some of a DBA's day-to-day needs. This article looks at some of the useful ones that we can add to our DBA or Developer toolbox.
Oracle Warehouse Builder Automated ETL Processing
:
Steve Callan offers a high level overview of what it takes to automate a load, covering each and every project item you need to address for this to work.
Multi Table Loop
:
This article examines how to loop through multiple tables to
process the data.
Create a Database Manually - When & Why?
:
Peering into the Oracle database creation process really pulls back the curtain on the inner workings of the database, allowing us to understand all of the levers, and pieces that make up a running Oracle database.
Cascading in Oracle: Friend or Foe?
:
Is cascading always a good thing? Steve Callan looks at some of the more common operations where cascade is used.
Keywords in Oracle
:
Some words in Oracle can be categorized as reserved words and keywords. Within the keywords category, context comes into play because a word isn't always reserved. Read on to learn how to distinguish between the two.
Oracle Database: Rotating Tables
:
Learn how to rotate a table to present the one to many relation between two tables as a one to one relation and present all the
matching records in a single row.
Handling NULLS in SQL statements
:
For some reason the ability to handle NULLS in SQL
statements can confuse some. This article takes a look at how to think of NULLs to avoid some confusion.
Multipurpose
code in Oracle and Oracle Forms : Take charge of what Oracle provides
out of the box by learning how to create a small message library to take care
of many types of output messages.
Data
Manipulation Using Java in Oracle : PL/SQL can do many things well, but
other languages can do some things much better, with “better” being measured in
terms of speed. If you find that stored data must be manipulated for display
type output, don’t be afraid to try other languages supported by Oracle.
Finding
Foreign Key Constraints in Oracle : For a developer to identify and
disable foreign key constraints is a difficult task. A brief description on the
foreign key (referential integrity) constraints will go a long way in
identifying and disabling these constraints. Read on to learn more.
Ordering
Events in Oracle : The time stamping and ordering of events within
Oracle is of prime importance and goes to the heart of how transaction control
and serialization are even possible. Read on to learn more about ordering
events in Oracle.
How
Does Oracle Perform Math? : Steve Callan discusses how to make your
database perform calculator-type functions, focusing on the LN(x) natural
logarithm function.
Finding
and Setting SQL*Plus Settings : Learn how to set up and create
customized settings files via the STORE command, and how to restrict access to
these files and other commonly used scripts.
Combining
Overloading and Session Management in Oracle : One feature often times
overlooked by developers is PL/SQL's ability to allow overloading. Learn how to
quickly and easily build a versatile session management tool, which can manage
one or many sessions.
The
Globalization of Language in Oracle - Terminology : With today's
exploding world economy, multi-national communication is essential. Databases
must not only store different character sets but also present information in a
comfortable format and order for individuals from every locale. This series
explores how to globalize your databases and communicate effectively across the
globe.
Oracle
and Regular Expressions : UNIX comes to Oracle in the form of regular
expressions to increase the power of searching.
Oracle
Response Files – Part 2 : Part One of Oracle Response Files covered the
basics of using a response file and provided an example of how to install
Developer Suite on a Windows PC. In Part Two, we will go into more detail about
the components of response files. This part will also discuss some related
topics as they pertain to the Oracle Universal Installer and some
Windows-analogous installation concepts.
Oracle
Response Files – Part 1 : Oracle's response files can be harnessed and
used to your advantage. Learn how to use this untapped resource that can save
you time and standardize installation of your Oracle products.
Oracle:
Choosing and Using the Right Code : Sometimes a programming background
can make a task harder than it is, especially if you lose sight of what SQL can
do independently of PL/SQL. Learn when it is to our best advantage to use a
pure SQL approach rather than switching to PL/SQL.
Just
SQL PartVIII : Grouping and summing at multiple levels often takes an
application to perform. Take a look at the ROLLUP operation within Oracle and
perform these operations in a single SQL statement.
Just
SQL Part VII – Hierarchical Queries : Whether they are called
hierarchical structures, trees, or self-referencing tables they often pose
quite a challenge to traverse in any simple manner. But Oracle has a solution.
Just
SQL Part VI – Two Famous Pseudocolumns : A pseudocolumn is a column
that looks like a column but really is not a column. What?! Stick around and
find out what a pseudocolumn really is. James Koopmann explores two popular pseudocolumns,
ROWID and ROWNUM, and their use.
Just
SQL Part V – Counting with SQL : How many do I have? Do I have at least
one? What is the greatest? What is the least? Give me the top 5 rows. These are
just some of the types of questions that are often asked when trying to
evaluate table data. This article explores how to translate these counting
questions into SQL statements.
Just
SQL Part IV – Joining Tables : As your database grows so will the need
to get information from more than one table. This article shows you the
different join options and offers some simple examples to raise your
familiarity.
Just SQL
Part III – Where is it? : We do not always want to SELECT everything
from a table. The matter of finding the information required is a function of
implementing the optional WHERE clause of the SELECT statement.
Just
SQL Part II – The Simple SELECT : At the core of most queries is an
underlying table structure. Part II of this series discusses how we can issue
the most basic of SELECT statements to extract information from a database
table.
Just
SQL Part I : How many of you have asked yourself what is SQL all about?
Join James Koopmann as he ventures down the road of understanding SQL and how
to take advantage of the language.
Playing
With MODELs: Oracle 10g SQL Enhancements, Part 3 : Oracle 10g has
extended the already robust features of Structured Query Language (SQL) with a
plethora of intriguing new capabilities. This article – the final in this
series – reviews the new features that Oracle 10g provides for advanced data
modeling and inter-row calculations via the new MODEL clause.
Data
Densification, Demystified: Oracle 10g SQL Enhancements, Part 2 :
Oracle 10g extends many of the already robust features of Structured Query
Language (SQL). This article the first of a series illustrates some of the more
intriguing new features of SQL within Oracle, including upgrades to the MERGE
command, enhancements to hierarchical query capabilities, and improvements to
query and access methods for nested tables.
Strong
SQL Made Even Stronger: Oracle 10g SQL Enhancements, Part 1 : Oracle
10g extends many of the already robust features of Structured Query Language
(SQL). This article the first of a series illustrates some of the more
intriguing new features of SQL within Oracle, including upgrades to the MERGE
command, enhancements to hierarchical query capabilities, and improvements to
query and access methods for nested tables.
Oracle 10g
PL/SQL Enhancements, Part 2: Utility Players : Oracle 10g has added
over fifty new PL/SQL packages and enhanced many of the existing packages, thus
expanding the Oracle DBA's toolkit once again. New capabilities include the
ability to transfer files between servers, more robust e-mail features,
improved compilation utilities, and character conversion utilities. This
article - the final one in this series - delves into several new features
presented in new and improved versions of Oracle's utility modules and illustrates
their usefulness in some real-world situations.
Oracle 10g
PL/SQL Enhancements, Part 1: DBMS_CRYPTO, DBMS_MONITOR, and DBMS_SERVER_ALERT :
With the addition of over fifty new PL/SQL packages as well as enhancements to
a majority of existing DBMS packages, Oracle 10g has added a plethora of new
tools to every Oracle DBA's tool belt. This article - the first is a series --
explores some of the more intriguing packages and illustrates their usefulness
in real-world situations.
Watching
SQL Execute on Oracle – Part II : Do you have SQL running within your
database? Of course you do. This article is the second in a series introducing
how to extract more information about the SQL that is executing in your Oracle
databases.
Watching
SQL Execute on Oracle – Part I : Do you have SQL running within your
database? Of course you do. This article, first in a series, introduces a
method of finding information about the SQL your users are executing in your
Oracle databases.
If you have an interesting
column / article / short note etc., that you would
like to share with the rest of the DBA world, please
send it to webmaster@dbasupport.com.
