Snipplr - mprabhuram

(Bash) What is the current shell you are in ?

Sat, 18 Jun 2011 00:46:56 GMT

To find out the current shell

(Bash) how to search / find files in Linux

Mon, 21 Mar 2011 11:00:19 GMT

(Bash) Linux Sort anything by any column

Mon, 21 Mar 2011 01:52:50 GMT

(Bash) Backing up Amazon EC2 Linux Instance

Sat, 05 Mar 2011 14:28:47 GMT

http://robpickering.com/2010/07/create-a-full-backup-image-of-your-amazon-ec2-instance-2-129

(SAS) Convert character field in to SAS date field

Wed, 02 Mar 2011 09:52:13 GMT

(SAS) Substring function

Wed, 05 Jan 2011 07:24:35 GMT

SUBSTRN(String,Start,count)

(Visual Basic) Find the last occurrence of a character in a string

Thu, 30 Dec 2010 03:59:18 GMT

I would like to find the position of the last occurrence of a character in a string and print every thing after that.

(SAS) SAS Oracle Bulk Load

Tue, 30 Nov 2010 06:14:29 GMT

use bulk load to save a large SAS dataset into oracle/DB2/SQL Server/ Teradata for joining with other tables etc.. Alternate link : http://www2.sas.com/proceedings/sugi29/106-29.pdf

(Bash) List directories by size in Linux / AIX

Thu, 28 Oct 2010 07:20:24 GMT

(Bash) Installing Mercurial Hg on Mac OSX

Sun, 24 Oct 2010 18:03:39 GMT

Mercurial Hg is a popular source code versioning system

(Bash) Installing wget on Mac OSX

Sun, 24 Oct 2010 17:41:05 GMT

Wget is a command line tool to download files from the internet.

(SQL) Cursor FOR LOOP

Wed, 08 Sep 2010 02:21:52 GMT

You would use a CURSOR FOR Loop when you want to fetch and process every record in a cursor. The CURSOR FOR Loop will terminate when all of the records in the cursor have been fetched.

(SQL) Elapsed Time Calculation & SLEEP

Tue, 31 Aug 2010 12:54:01 GMT

Elapsed Time Calculation

(SQL) Generate HASH Value for a string

Tue, 31 Aug 2010 12:51:58 GMT

GET_HASH_VALUE Function This function computes a hash value for the given string. Syntax DBMS_UTILITY.GET_HASH_VALUE ( name VARCHAR2, base NUMBER, hash_size NUMBER) RETURN NUMBER;

(SQL) Return Database Version

Tue, 31 Aug 2010 12:26:55 GMT

Returns database's version

(SQL) Dynamic SQL - Stored procedure

Mon, 30 Aug 2010 13:48:22 GMT

other links : http://tinman.cs.gsu.edu/~raj/880/su98/pldsql/node6.html

(SQL) Variable Declaration Using Database Objects %rowtype

Mon, 30 Aug 2010 10:29:21 GMT

In the examples so far we have declared variables as a separate object using one of PL/SQL’s standard datatypes. Normally a PL/SQL variable is closely tied to a database object and uses the same datatype. For example, if the variable will hold the book title from the book table , the variable definition must be of the exact same type and size as the table column. But what happens when the DBA changes the book table so that book_title is defined as a varchar2(60) instead of a varchar2(40)? It’s important to program in such a way that when the tables are changed, the PL/SQL code does not always need to be changed

(SQL) Logic to subtract months from a date field and extract run_yr_mo

Fri, 20 Aug 2010 00:17:29 GMT

Logic to subtract months from a date field and extract year and month

(SQL) Oracle Sequence

Sat, 14 Aug 2010 05:09:31 GMT

Sequence is used to generate auto incrementing numbers

(Bash) Add date and time to filename

Mon, 26 Jul 2010 16:55:00 GMT