Get the Current Date for PL/SQL
This is not really a post, just a small note on an item that can make you lose precious time hunting for… To get the current date in a PL/SQL query in order to compare it with other fields or data from the Oracle database, do this: select extract(year from sysdate) from dual This gets [...]
Full StorySetting Up a Web Application using ColdFusion and Oracle on the same host
I was asked by a client to test some application features onsite and needed to re-create the environment on a single computer using ColdFusion with Oracle as database and had a hard time figuring out what the installation order is and get everything work together.
Full Story