The SQL MODEL clause
The SQL MODEL clause was introduced as a new feature in Oracle 10g. Mark Rittman has a good article about how to use the new clause to generate financial statements.
Filed in Oracle with Comments Off | Tags: model, sqlWhat’s ahead for ColdFusion
The upcoming CFMX 7 updater, codenamed “Merrimack”, is in beta and will be released later this year. The updater will provide, in addition to bug fixes, improved platform support and will surface the “CFCProxy” machinery to allow Java code to call ColdFusion Components. The platforms include: Mac OS X native installer, RHAS 3.0 / 4.0, SuSE ES 8 / 9, WSND, OAS 10g.
The next release of ColdFusion (CFMX8?) is codenamed Scorpio! It is still in its very early days. Two of the areas that the Macromedia developers are looking at, based on requests from customers, are:
- Enhancing the presentation features and functionality
- Monitoring and access to the server internals (via)
ColdFusion + AJAX = CFAjax
If you are like me, you will not shy away from exploring new technologies. AJAX is becoming more and more popular among web developers. If you use ColdFusion and would like to take advantage of all the cool things AJAX can do, CFAjax is for you.
CFAjax is the AJAX implementation for ColdFusion. It makes ColdFusion method calls on the server directly from HTML page using JavaScript and returns back the result to the calling HTML page. CFAjax comes with simple to use JavaScript API and simple ColdFusion implementation that marshal’s the response between your ColdFusion methods and your HTML page.
Filed in ColdFusion with 2 Comments | Tags: ajaxOracle time zones
A couple of nice-to-know queries:
SELECT SESSIONTIMEZONE FROM DUAL;
returns the time zone of the client session.
SELECT DBTIMEZONE FROM DUAL;
returns the time zone of the database server.
Filed in Oracle, Tips with Comments OffNVL2 in Oracle
Did you know that in addition to the function NVL, Oracle also has the function NVL2? which is quite different than its cousin NVL. So, what does NVL2 do? (more…)
Sharing big files on the Internet
It is not always easy to attach those big files to e-mail messages as the attachment limit for most ISPs is about 10MB. Don’t be disappointed – there are some slick –and free–Web sites for sending really big files. Both Dropload and YouSendIt let you send single files of up to 1GB in size. (Warning: For professional users on fast broadband connections, only. Do not try this on dial-up.)
Both Dropload and YouSendIt are quick n’ easy to use, with no ActiveX installations or other hassles. With YouSendIt, just tell the site the location of the file on your drive and who the file goes to, and the file is on its way. I like being able to send the file to multiple addresses. Dropload’s advantage is that once you’re registered (and don’t worry, it’s benign), you can save recipient e-mail addresses. That’s handy if you need to send a file to the same person at a later date.
Using another free service RapidShare, you can upload the file on their server and Rapidshare give you a unique URL for each uploaded file. However, free users have to wait for a few seconds before the download begins. And only Premium Member can resume broken downloads.
Quick Tip: All these services allow only single files to be sent. If you have more than one file, just zip them into an archive file with any one of a bunch of free compression utilities downloadable from PC World like FreeZip. (Via)
Filed in Technology, Tips with Comments Off | Tags: file, internetOracle PL/SQL package initialization
Did you know that Oracle PL/SQL packages can have an initialization section? The initialization part of a package is run only once, the first time you reference the package. Here is an example: (more…)
Filed in Oracle with 1 Comment | Tags: pl/sqlCFLOCATION behavior change in CFMX7
Right after I upgraded to CFMX7 a while back, I started getting the following error on some of my pages:
ColdFusion was unable to perform the CFLOCATION operation. Location URL cannot contain (carriage return) CR or (line feed) LF characters
I noticed that all of the pages that were generating this error had the function encrypt within the cflocation tag. After a little bit of digging, I found out that the encrypt function may generate an encrypted string that will contain carriage return (CR) and line feed (LF) characters, which is considered a security hole. For this reason, beginning with ColdFusion MX 7, cflocation will no longer allow URL’s to contain CR and/or LF characters.
The solution proposed by Macromedia in one of their technotes was that instead of passing encrypted data from one ColdFusion template to another using URL variables appended to the URL specified in the cflocation tag, save the data to an Application, Client or Session variable (whichever makes sense for the data at hand) on the originating template and then read it out on the target template. This solution worked well for me.
Oracle making JDeveloper free
From Oracle JDeveloper’s FAQ answering the question: Why is Oracle making JDeveloper free?
Filed in Oracle with Comments Off | Tags: jdeveloper, toolFree tools have an undeniable momentum right now in the Java development community. Oracle is taking free tools to a more advanced level of SOA application development by offering more than just a free Java IDE: Oracle is offering its complete SOA development environment at no cost. Oracle is committed to helping developers build standards-based enterprise Java and SOA applications, and in return, Oracle hopes to improve developer affinity for Oracle’s leading-edge Oracle Fusion Middleware product family.
Free Google Earth is here
From the Google Blog:
Last October Keyhole and Google joined forces to integrate satellite imagery with Google search technology in a single product. Now we’ve landed on Google Earth. You can fly from space right down to any place on the planet and take in spectacular 3D views, and for major US cities you can now see 3D city models. And more: where Google Local works today (the U.S., Canada, and the U.K.), you can search Google Local from within Earth for points of interest, businesses listings, driving directions, and lots more (like some of these excellent locations). True to Google form, there is now a free version. Ready to explore?
I downloaded Google Earth and started playing with it. My reaction: WAOH!
Filed in Technology with 4 Comments | Tags: Google
