Creating a CV indexing facility using Oracle Text

Recently, I have struggled to get Oracle Text working on Linux. It was supposed to be a simple addon based on a very simple idea: + already installed Apache 2.2, PHP 5.3, Firebird 2.0; which are working fine + install Oracle 10g Express Edition + create a simple table to store candidate ID and document … Read moreCreating a CV indexing facility using Oracle Text

Emergency check on command-line for Oracle XE

Go to your Oracle binaries folder and export environment variables, if they are not set already. Then, run SQL*Plus command line utility with option /nolog .

I hope this helps some beginners.

Setting up a web application on CentOS (continued)

Before continuing the rest of the installation process we started (/wp/index.php/2009/07/setting-up-a-web-application-on-centos-5-3/), I must mention my appreciation for the “yummy” tool Linux developers provided: yum (.. an automatic updater and package installer/remover for rpm systems). I love using webmin (.. a web-based interface for system administration for Unix) as well. The other day I only clicked … Read moreSetting up a web application on CentOS (continued)

Paging records in MS SQL Server 2005

After years of torturing their SQL Server users, Microsoft provided a “better” way of paging records in version 2005, and it is a weird one! The following example is from their website, an article about ROW_NUMBER (Transact-SQL).

It is simply unacceptable, non-standard, impractical! By the way, you can not use column numbers (e.g. ORDER … Read morePaging records in MS SQL Server 2005