Whats your favorite Oracle "How To..." ?

[websmythe]

PopUp Windows
I just started with Oracle 10 XE (Express Edition) and found a kool How To on creating PopUp Windows in Application Express
http://www.oracle.com/technology/products/database/application_express/howtos/how_to_create_custom_popups.html

[Memento]

I always start with Google for PL/SQL questions. It sometimes takes me to techonthenet.com (syntax refresher) or expertsexchange.com but I never start my search with those sites. As a last resort I will occasionally browse the documentation for some tidbit. You can’t search for something if you don’t know it exists.

The latest thing I have stumbled upon is the Flashback Versions query (10g) which allows you to see all the changes to a record for however far back your undo table space goes. This is useful for comparing what happens when I change something in an application and want to see the before and after.

[websmythe]

Does sound useful, gotta link??

[Memento]

Oracle's Flashback Overview

Oracle Code Example

[websmythe]

Thanx. Looks like Giganto Triple Mohcachino material. ...Kool.

[Memento]

Thanx. Looks like Giganto Triple Mohcachino material. ...Kool.

It can get complicated but here is a simple example. If the unique record 1234 had been changed in the last two days, we would see a row for each change. There are also pseudo columns you can add to see when each change was made.

SELECT tableAlias.* 
  FROM some_modified_table versions 
       between timestamp SYSDATE-2 and SYSDATE tableAlias 
 WHERE tableAlias.primaryKey= 1234

[websmythe]

Definate mileage in that one... Now that I'm a couple a weeks far down the road...:) Can definately see a couple of use for that. Kool.

[websmythe]

Actually now that I think about it... You've just given me a major clue into how "possibly" implement an offsite backup.... Thanx!