Lokeshwaran dlokesh

Oracle sqls

select * from all_constraints where table_name='TABLE_NAME' and owner='OWNER_NAME';

SELECT cols.table_name, cols.column_name, cols.position, cons.status, cons.owner

perl -p -i -e 's/oldstring/newstring/g' *
sed -i ‘s/oldstring/newstring/g’ *
find app/views/ -type f -exec perl -p -i -e 's/alert.unit/unit/g' {} \;

git branch --set-upstream prod origin/prod

SELECT datname,usename,procpid,client_addr,waiting,query_start,current_query FROM pg_stat_activity;

sudo sysctl -w kern.sysv.shmmax=209715200

	<?xml version="1.0" encoding="UTF-8"?>
	<project xmlns="http://maven.apache.org/POM/4.0.0"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>

	<name>hello</name>
	<groupId>com.hello.service</groupId>
	<artifactId>hello-service</artifactId>
	<version>1.0.1-SNAPSHOT</version>

	# Something in lines of http://stackoverflow.com/questions/348630/how-can-i-download-all-emails-with-attachments-from-gmail
	# Make sure you have IMAP enabled in your gmail settings.
	# Right now it won't download same file name twice even if their contents are different.

	import email
	import getpass, imaplib
	import os
	import sys

	detach_dir = '.'

	# http://www.cocoanetics.com/2012/07/you-dont-need-the-xcode-command-line-tools/
	RECEIPT_FILE=/var/db/receipts/com.apple.pkg.DeveloperToolsCLI.bom
	RECEIPT_PLIST=/var/db/receipts/com.apple.pkg.DeveloperToolsCLI.plist

	if [ ! -f "$RECEIPT_FILE" ]
	then
	echo "Command Line Tools not installed."
	exit 1
	fi

	brew install fuse4x
	brew install ntfs-3g
	sudo mv /sbin/mount_ntfs /sbin/mount_ntfs.orig
	sudo ln -s /usr/local/Cellar/ntfs-3g/2013.1.13/sbin/mount_ntfs /sbin/mount_ntfs

	# Install kernel extensions
	sudo cp -rfX /usr/local/Cellar/fuse4x-kext/0.9.2/Library/Extensions/fuse4x.kext /Library/Extensions
	sudo chmod +s /Library/Extensions/fuse4x.kext/Support/load_fuse4x

	yum install git
	yum -y install make gcc gcc-c++ kernel-devel
	yum install openssl

	wget https://github.com/joyent/node/archive/v0.4.9.zip
	cd node-0.4.9
	./configure --prefix=/opt/node
	make -j2
	sudo make install
	echo 'export NODE_PATH=/opt/node:/opt/node/lib/node_modules' >> ~/.bashrc