How to turn off drupal messages
A red error message displaying on your webpage, visible to every visitor is the worst thing you can do to your site. Unfortunately, drupal displays error messages on the screen…
How to manipulate files with software installed on your local Mac OS
To access remote files, you need to either SSH or FTP into a server. If you have an SSH account, you can use the server’s command line software to edit…
Setting up clean URLs in drupal
Setting up clean URLs Drupal URLs have the format http://www.molecularsciences.org/?q=node/11. ‘?q=’ does not look very nice in the URL. It also hinders using meaningful URLs. Search engines such as google…
Porting drupal configuration with configuration management module
This article explains how to port drupal configurations from one site to another. First we will create a custom content type and then port it over to another drupal site.…
Oracle decode() function
Decode function has the same functionality as an IF-THEN-ELSE statement. It is present in Oracle 9i and above. It has the syntax For example, This is like saying the following…
What is an Oracle Package
A package is an encapsulated collection of related PL/SQL types, objects, procedures, and other program objects. Packages have a package specification and a package body. Package specification declares constants, variables,…
Quick Introduction to Apache Spark
Spark a distributed computing platform that is built on top of Hadoop MapReduce. It extends the MapReduce model and make it easier to code and faster to execute. Spark provides…
Commonly used code in Oracle
Changing case To change the first letter of the word to cap, use the inicap function. Use upper to covert to uppercase and lower to convert to lower case. Examples:…
What is PL/SQL
Procedural Language extension of SQL (PL/SQL) combines SQL with procedural programming features such as looping, conditionals, and reusable blocks. PL/SQL engine processes PL/SQL statements. PL/SQL statements can reside on the…
Oracle set operators: union, intersect, minus
The most commonly used set operators in Oracle are: union intersect minus Union Union combine results returned by two or queries into a single table. In a union, all tables…