Miscellaneous
SQL Themes
|
|
ANSI Join Syntax
|
Starting with 9i there is
an alternative way to (+) .... (see here)
|
|
Partitioned Outer Join
|
A feature for "gap
fillers" in 10g. A discussion and further links can be found here
|
ROWNUM=1
SELECT
|
Read the true story of a
select with ROWNUM=1 that caused more
than 100K PIO
|
Analytic
Functions
|
A summary of the most
important analytic
functions using a simple product sales example
|
How
to Get Partition Name
|
How to assign the partition name for each row in the
table?
|
Sense
of Humour
|
Does Oracle have a Sense of Humour?
|
Synthetic
Analytic
|
More on analytic functions in Oracle
|
Happy
New Peek
|
Sometimes the execution
plan is only a plan. A little demonstration that bind
variable peek phenomenon is not limited to an existence of histogram. A
peek on a partitioned table may change the plan in unpredicted way …
|
How
to Change the public IP Address in an Oracle RAC
|
This task is trivial, but
not always… Read more here
|
|
|
|
|
|
|
|
|
|
|
Metalink
|
Some links that I or others found interesting
|
Search
Metalink
|
To search Metalink
|
