Browse: Home / Oracle

Oracle

Get the Current Date for PL/SQL

Get the Current Date for PL/SQL

By Sanda Borlea on December 23, 2005

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 [...]

Posted in | Tagged , , | 3 Responses

Setting Up a Web Application using ColdFusion and Oracle on the same host

Setting Up a Web Application using ColdFusion and Oracle on the same host

By Sanda Borlea on November 22, 2005

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.

Posted in , | Tagged , ,