User Name Password Register
DaniWeb IT Discussion Community
Home
Forums
Tutorials
Code Snippets
Blogs
Link Directory
All
•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 425,935 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,613 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Join our community!
Please support our Oracle advertiser: Programming Forums
Views: 1610 | Replies: 7
Reply
•
•
Join Date: Oct 2006
Posts: 15
Reputation: websmythe is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
websmythe's Avatar
websmythe websmythe is offline Offline
Newbie Poster

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

  #1  
Mar 22nd, 2007
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/pro...om_popups.html
AddThis Social Bookmark Button
Reply With Quote  
•
•
Join Date: Jan 2007
Location: Austin, TX
Posts: 30
Reputation: Memento is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
Memento Memento is offline Offline
Light Poster

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

  #2  
Mar 23rd, 2007
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.
Dan Moore
www.danmoore.org
Reply With Quote  
•
•
Join Date: Oct 2006
Posts: 15
Reputation: websmythe is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
websmythe's Avatar
websmythe websmythe is offline Offline
Newbie Poster

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

  #3  
Mar 23rd, 2007
Does sound useful, gotta link??
Reply With Quote  
•
•
Join Date: Jan 2007
Location: Austin, TX
Posts: 30
Reputation: Memento is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
Memento Memento is offline Offline
Light Poster

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

  #4  
Mar 23rd, 2007
Oracle's Flashback Overview

Oracle Code Example
Dan Moore
www.danmoore.org
Reply With Quote  
•
•
Join Date: Oct 2006
Posts: 15
Reputation: websmythe is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
websmythe's Avatar
websmythe websmythe is offline Offline
Newbie Poster

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

  #5  
Mar 24th, 2007
Thanx. Looks like Giganto Triple Mohcachino material. ...Kool.
Reply With Quote  
•
•
Join Date: Jan 2007
Location: Austin, TX
Posts: 30
Reputation: Memento is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
Memento Memento is offline Offline
Light Poster

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

  #6  
Mar 24th, 2007
•
•
•
•
Originally Posted by websmythe View Post
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.

Help with Code Tags
sql Syntax (Toggle Plain Text) 
  1. SELECT tableAlias.* 
  2.   FROM some_modified_table versions 
  3.        BETWEEN timestamp SYSDATE-2 AND SYSDATE tableAlias 
  4.  WHERE tableAlias.primaryKey= 1234
Dan Moore
www.danmoore.org
Reply With Quote  
•
•
Join Date: Oct 2006
Posts: 15
Reputation: websmythe is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
websmythe's Avatar
websmythe websmythe is offline Offline
Newbie Poster

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

  #7  
Apr 5th, 2007
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.
Reply With Quote  
•
•
Join Date: Oct 2006
Posts: 15
Reputation: websmythe is an unknown quantity at this point 
Rep Power: 2
Solved Threads: 0
websmythe's Avatar
websmythe websmythe is offline Offline
Newbie Poster

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

  #8  
Apr 5th, 2007
Actually now that I think about it... You've just given me a major clue into how "possibly" implement an offsite backup.... Thanx!
Reply With Quote  
Reply

•
•
•
•

Only community members can participate in forum threads. You must register or log in to contribute.

Register
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

•
•
•
•
Thread Tools Display Modes
Linear Mode Linear Mode

Similar Threads
Other Threads in the Oracle Forum

Advertising Opportunities on DaniWeb
Contact Us - Newsletter Archive - Sitemap - Privacy Statement
All times are GMT -4. The time now is 9:19 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC