Archive for the ‘Solving Problems’ Category

Dynamic runtime evaluation of the PL/SQL expressions

Sunday, August 24th, 2008

Quite frequently the people who have to work with PL/SQL and who have some experience with other programming languages (like me) are looking for familiar mechanisms to solve their problems. One of these mechanism is dynamic evaluation of the language expressions commonly used in Unix shell, Perl and other languages. It actually turns out that [...]

Using custom exceptions in Oracle PL/SQL

Thursday, July 3rd, 2008

Exception handling mechanism is a very important feature of PL/SQL. In most of the cases it is much simpler to just attempt an operation and properly handle the expected failure rather than to check for the conditions before attempting an operation. For example: it is much easier to unconditionally attempt to drop a table and [...]

Using GNU Date - tricky date/time manipulations

Wednesday, January 23rd, 2008

I love shell scripting. This is something that the typical Windows users usually do not understand. They have to download tons of buggy shareware utilities to do something simple. In UNIX you can do a lot of tricky things with the standard tools that come with the system (in case of Linux - for free). [...]

Exploring System Internals with lsof and strace

Friday, July 20th, 2007

This article describes various approaches to looking at the processes in you UNIX environment. Unlike other operating systems, most of the UNIX systems allow you to get a lot of information about the state of the system, processes, I/O, networking etc.

Why and when do you need it? There may be endless list of situations that [...]