Archive for the ‘Database’ Category
You are currently browsing the archives for the Database category.
7
Oct
2009
Query on the Long Column or Field
A typical problem in any EAI project. Others too!!
One of the most common ways of building custom Error Handling or Logging mechanisms include dumping huge messages and XMLs in the database for future reference. It works as an excellent logging mechanism which can be pulled out in case something in the system fails.
10
Aug
2009
ORACLE – DUAL Table
One of the first things that any introductory SQL tutorial teaches, is about the DUAL table in Oracle. It is the commonest of the lot, and extremely useful, I must say. The DUAL table is installed automatically with the standard Oracle Data Dictionary at the time of installing the ORACLE Database itself.
