Snipplr

(Bash) Protect your existing private rsa key with a passphrase - mprabhuram

Sun, 01 Sep 2013 00:13:21 UTC

You can also use this to change the pass phrase of ur existing password protected private key

(Bash) Convert VMWARE vmdk file to VIRTUALBOX vdi file - mprabhuram

Tue, 23 Jul 2013 23:40:27 UTC

Companies provide a virtual image to test drive their software. Often the virtual machine is in vmware format. Use this to convert vmware vmdk file to virtualbox vdi file. Create a new virtualbox machine using this vdi. You are ready to go testing the virtual machine on virtualbox

(Visual Basic) Time Based Gantt Chart in Excel - mprabhuram

Sat, 15 Jun 2013 03:53:16 UTC

I wanted a time based gantt chart in excel. Robert's excel template was very useful. The hourly gantt chart was not useful to visualize my needs. I need something with 10 mins precision to analyse patterns in jobs that are running under 15 mins. So the following is the formula that i used to achive it. Its not perfect and i dont have time for perfect right now. Some time later i will have to get back to this and publish a excel template.

(SQL) CASE statement to transpose rows in to columns - mprabhuram

Thu, 13 Jun 2013 02:45:46 UTC

This SQL would help you to transpose a rows into columns in SQL

(Visual Basic) Banding of timestamp or date into 5 min bands using excel - mprabhuram

Thu, 13 Jun 2013 02:43:19 UTC

This would round down the time stamp to the nearest 5 minute interval based on first interval being 00:00:00.

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

Sat, 18 Jun 2011 00:46:56 UTC

To find out the current shell

(Bash) how to search / find files in Linux - mprabhuram

Mon, 21 Mar 2011 11:00:19 UTC

(Bash) Linux Sort anything by any column - mprabhuram

Mon, 21 Mar 2011 01:52:50 UTC

(Bash) Backing up Amazon EC2 Linux Instance - mprabhuram

Sat, 05 Mar 2011 14:28:47 UTC

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 - mprabhuram

Wed, 02 Mar 2011 09:52:13 UTC

(SAS) Substring function - mprabhuram

Wed, 05 Jan 2011 07:24:35 UTC

SUBSTRN(String,Start,count)

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

Thu, 30 Dec 2010 03:59:18 UTC

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 - mprabhuram

Tue, 30 Nov 2010 06:14:29 UTC

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 - mprabhuram

Thu, 28 Oct 2010 07:20:24 UTC

(Bash) Installing Mercurial Hg on Mac OSX - mprabhuram

Sun, 24 Oct 2010 18:03:39 UTC

Mercurial Hg is a popular source code versioning system

(Bash) Installing wget on Mac OSX - mprabhuram

Sun, 24 Oct 2010 17:41:05 UTC

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

(SQL) Cursor FOR LOOP - mprabhuram

Wed, 08 Sep 2010 02:21:52 UTC

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 - mprabhuram

Tue, 31 Aug 2010 12:54:01 UTC

Elapsed Time Calculation

(SQL) Generate HASH Value for a string - mprabhuram

Tue, 31 Aug 2010 12:51:58 UTC

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 - mprabhuram

Tue, 31 Aug 2010 12:26:55 UTC

Returns database's version

(SQL) Dynamic SQL - Stored procedure - mprabhuram

Mon, 30 Aug 2010 13:48:22 UTC

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

(SQL) Variable Declaration Using Database Objects %rowtype - mprabhuram

Mon, 30 Aug 2010 10:29:21 UTC

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 - mprabhuram

Fri, 20 Aug 2010 00:17:29 UTC

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

(SQL) Oracle Sequence - mprabhuram

Sat, 14 Aug 2010 05:09:31 UTC

Sequence is used to generate auto incrementing numbers

(Bash) Add date and time to filename - mprabhuram

Mon, 26 Jul 2010 16:55:00 UTC

(Bash) Unix Script control flow - mprabhuram

Mon, 26 Jul 2010 14:56:45 UTC

you could divide your job into functions Here, procedure_1 is the first part of the job, where there isn't restart, procedure_2 must be executed if procedure_1 was done and the control logic is at the end, working as an outer loop.

(Bash) Unzip & Untar a .gz file on mac - mprabhuram

Mon, 26 Jul 2010 14:48:29 UTC

(Bash) Download a file using Terminal in MAC (cURL) - mprabhuram

Mon, 26 Jul 2010 13:59:14 UTC

cURL can be used in place of wget Use this command to download a file into filesystem using terminal.

(Bash) Add to PATH , change directory script - mprabhuram

Mon, 26 Jul 2010 13:18:40 UTC

http://forums.macrumors.com/showthread.php?t=407157

(Visual Basic) How do I create a named cell in Microsoft Excel? - mprabhuram

Thu, 08 Jul 2010 08:52:19 UTC

A named cell or range in Microsoft Excel enable users to quickly and easily remember a cell's reference name. For example, it's much easier to remember Total than it is to remember G23.

(SQL) Push_subq Oracle hint - Execute the sub query before the parent query - mprabhuram

Wed, 07 Jul 2010 22:13:18 UTC

(SQL) Create/ View/ Delete DB Links in oracle - mprabhuram

Wed, 07 Jul 2010 02:20:19 UTC

See the DBLinks that you have created in the past

(SQL) Oracle TimeStamp to Char conversion - mprabhuram

Fri, 02 Jul 2010 06:35:07 UTC

use this to convert the oracle time stamp into a character.

(SQL) Regular expression to convert alphanumeric field into numeric field - mprabhuram

Mon, 21 Jun 2010 19:50:34 UTC

This will take the alpha numeric loan number field and converts it into numeric loan number. If there are any loan numbers with alphabet then it is converted as NULL (basically alpha numeric loan numbers are ignored)

(SQL) How to avoid double counting - mprabhuram

Fri, 04 Jun 2010 15:01:36 UTC

Use this logic to avoid double counting in ORACLE SQL

(SQL) Oracle - Overlaps function - mprabhuram

Fri, 04 Jun 2010 09:20:48 UTC

This function can be used to find out if there exists an overlap between two pairs of dates or time. There is an alternate way to calculate the actual overlapping value - Read the snippet "How to avoid double counts"

(SQL) Ranking Function - Range over partition - Oracle Analytical function - mprabhuram

Wed, 19 May 2010 14:27:08 UTC

ROW_NUMBER() - Partition (group by) the expression values and assigns integer values to the rows depending on their order. thx to Shouvik Basu < http://www.orafaq.com/node/55 >

(Other) S3CMD tool : Amazon S3 command Line tool - command reference - mprabhuram

Sun, 25 Apr 2010 13:58:07 UTC

(Visual Basic) Merge cells in multiple selected areas Column by Column - mprabhuram

Fri, 12 Feb 2010 14:43:25 UTC

(Visual Basic) ZoomOut Excel Macro - mprabhuram

Fri, 12 Feb 2010 10:55:04 UTC

This macro sets the bottom boundary at 10%, which is the smallest you can go. Any smaller, and Excel would generate an error again.

(Visual Basic) ZoomIn Excel Macro - mprabhuram

Fri, 12 Feb 2010 10:53:52 UTC

Notice that the macro only allows you to zoom in up to 400%. This is because Excel allows you to only zoom that high, and any higher would generate an error. A slight variation on the same theme results in a macro I call MyZoomOut. It zooms out of (reduces) a worksheet by 10%:

(ActionScript 3) Creating and modifying remote shared objects from flex client - mprabhuram

Thu, 17 Sep 2009 02:23:29 UTC

This is a sample application to demonstrate how to create and modify remote shared objects in a flex client application

(ActionScript 3) Flex Data Validator - Phone number validator - mprabhuram

Tue, 28 Jul 2009 04:52:55 UTC

Use this as a sample script to code flex data validations

(Bash) Shell Script For Collecting Information on the Linux Network Configuration - mprabhuram

Wed, 15 Jul 2009 15:46:13 UTC

This shell script is tested under CentOS / RHEL and Fedora Linux. It should also work under other Linux distributions. If you would like to collect and submit information on your network configuration to your sr. Linux / UNIX admin use this script.

(ActionScript 3) KeyPress/keyboard events handling in Flex AS3 - mprabhuram

Tue, 14 Jul 2009 02:38:44 UTC

Use this code to handle keypress/keyboard events