The Chocolate Factory
Today we went to the theater and saw the movie Charlie and the Chocolate Factory. My son and my wife liked it a lot. It is a very good family movie I must admit. If you go see it you won’t be disappointed.
Rename column or constraint in Oracle
Prior to Oracle 9i it was difficult to rename a column or a constraint. In Oracle 9i and above, this can be easily accomplished using the ALTER TABLE command. Here is an example:
Continue reading…
XML configuration files used in ColdFusion MX
If you ever wondered what the purpose and location of the ColdFusion XML configuration files are, you have to read this ColdFusion TechNote. It describes the J2EE-standard XML files used by ColdFusion MX, the ColdFusion MX-specific XML server configuration files, and the XML files used to store ColdFusion MX Administrator settings. Very informative and useful.
Comments Off | Filed in ColdFusion | Tags: configuration, xmlMy WordPress Plugins
I like WordPress. I used to be a big Blogger.com fan, in fact, I still have my old blogspot blog. But, since I moved to WordPress, I realized how limited Blogger.com was and how amazing WordPress is. The fact that you can extend WordPress with the use of plugins, makes this blogging package even more powerful. Here is the list of plugins I currently have installed on this site: Continue reading…
1 Comment | Filed in Personal, Technology | Tags: plugin, WordPressdel.icio.us direc.tor on AJAX
del.icio.us direc.tor is a prototype for an alternative web-based rich UI for del.icio.us. It leverages the XML and XSL services of modern browsers to deliver a responsive interface for managing user accounts with a large number of records.
The main features are:
- In-browser handling of del.icio.us bookmarks (tested up to 12,000 records)
- Find-as-you-type searching of all your bookmarks, with basic search operators
- Sort by description, tags, or timestamp
- Ad-hoc tag browser
Read all about it here
Comments Off | Filed in Technology | Tags: ajax, del.icio.usWhat is the COST?
If you use the Cost Based Optimizer (CBO) in your Oracle database, you may be surprised to know that decreasing the ‘COST’ of a query does not necessarily mean increased performance. Continue reading…
1 Comment | Filed in Oracle | Tags: optimizer, query, tuningQueries and Totals in ColdFusion
While reading the CF-Talk e-mails, I noticed a couple of interesting, yet simple, facts about queries and totals in ColdFusion. First, in any query, queryName["columnName"] returns an array of columnName values. Second, if you want to calculate the sum of columnName values, you can simply use the function arraySum(). Here is an example (tested on CFMX7): Continue reading…
CASE used in CREATE INDEX
The following is a neat way to index id1,id2 when id is not null, and index NULL,NULL (which won’t be indexed) when it is: Continue reading…
Google Extensions for Firefox
Firefox users, rejoice. Google has introduced the following Firefox extensions:
Enjoy.
Comments Off | Filed in Firefox | Tags: extension, Firefox, GoogleUsing CUBE to generate rows
When I find a cool trick like the one I am going to tell you about here, I immediatly post it on my blog so that I can find it later when I need it, and also share it with the rest of you. I just love such tricks. A few days ago, I talked about generating rows from DUAL; There is another way to generate rows, using CUBE.
So, how can CUBE generate rows? Continue reading…
