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
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 .
[root@localhost /]# cd /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/
[root@localhost bin]#. ./oracle_env.sh
[root@localhost bin]# sqlplus /nolog
SQL> connect myuser/mypassword@localhost/xe
SQL> select count(*) as c from mytablespace.mytable
I hope this helps some beginners.
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)
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).
WITH OrderedOrders AS
SELECT SalesOrderID, OrderDate,
ROW_NUMBER() OVER (ORDER BY OrderDate) AS 'RowNumber'
WHERE RowNumber BETWEEN 50 AND 60;
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