Archive for category Oracle
Log Mining in Oracle 10g
If you ever had to perform log mining in Oracle prior to 10g, you will be pleasantly surprised by how easy and fast it is in 10g. After using 10g for several years, I finally got a chance to use log miner in 10g. Until now, flashback queries were always enough to recover errant deletes [...]
Oracle Function to Create CFQuery
Posted by me in ColdFusion, Oracle on March 10th, 2009
Rather than creating insert and update queries in ColdFusion against an Oracle database, this function can generate the code for you. I haven’t added cfqueryparam to check the datatypes, but that would be ideal at helping prevent SQL Injection attacks.
Oracle Function to Create CFForm
Posted by me in ColdFusion, Oracle on March 10th, 2009
If you use table and column comments, you can create an Oracle function that will create insert and update forms for you complete with table formatting and data type form fields that are limited to the number of chars in a column.
Three Simple Date Functions
Over the years, I found that I was always typing the same lines of code to get at a very simple piece of information. At first, writing date functions seemed like a dumb idea. I mean, why would you need a function that returns the first day of a given month? The first of the [...]
-
You are currently browsing the archives for the Oracle category.
