Monthly Archives: December 2012

Oracle SQL Boolean Expressions

We use boolean expressions nearly all of our SQL’s. Boolean expressions are necessary to manipulate data according to business rules. But we must be careful, because SQL might return some values in Select statements, but this may not be what … Continue reading

Posted in Oracle | Tagged , , , , , , , , | Leave a comment

Getting Ready To Static Code Analyze With Sonar-Runner (for Windows)

As a developer, I think static code analysis is very important. Our code is getting bigger day by day with the wishes of our customers. We have super time constraints and we must finish our development before strict deadlines. Because … Continue reading

Posted in Java | Tagged , , , , , , , | 11 Comments

Sending Mail with Multiple Attachment In PL/Sql

Oracle provides you two different packages for sending mail. Utl_Smtp package firstly introduced in Oracle 8i and Utl_Mail package firstly introduced in Oracle 10g. In my post, I will give example with Utl_Smtp package. First of all you need to … Continue reading

Posted in Oracle | Tagged , , , , , , , | 68 Comments