efficient distinct queries

- Posted by

For some use cases distinct queries can be written more efficiently than by simply using select distinct... Conditions that should be met: you are dealing with a "large" table, otherwise you might ... more

huge in clauses

- Posted by

Let's imagine we are given a 5000 record file and need to match ids from it to a 1 million row table and retrieve values from that table. What options do we have? select values from our record table ... more

Check last_analyzed age distribution

- Posted by

Find below a simple query that let's you quickly check how old your table statistics are. def agelimit = 30 column age format a3 column cnt format 99999 column graph format a10 set pagesize 999 set ... more

host based trigger authentication

- Posted by

Preventing certain machines from connecting to your database can be accomplished by triggers. Oracle however has some safety measures to prevent you from locking yourself. First you cannot keep ... more

Identities, Triggers and Sequences

- Posted by

Oracle in 12c finally introduced the option to source column default values from sequences. I wanted to know how this new feature compares to doing the same thing manually with sequences, larger ... more

Page 1 of 3