Jailbreaking and deploying on iphone3gs using ios5

First jailbreak using latest version of redsnow : 

http://osxdaily.com/2011/12/27/how-to-jailbreak-ios-5-0-1-untethered-with-redsn0w/

Then follow these instructions to run/deploy your app on your iphone : 

stackoverflow.com/questions/246422/how-can-i-deploy-an-iphone-application-from-xcode-to-a-real-iphone-device 

Installing node.js on hostmonster/bluehost

http://rcrisman.net/article/10/installing-nodejs-on-hostmonster-bluehost-accounts

While installing git you many want to get the latest source from http://git-scm.com/download

Oracle finding columns

 
 finding columns
 Find all tables that have at least one column that matches a specific PATTERN in the column name

 SELECT       TABLE_NAME,       COLUMN_NAME    FROM       ALL_TAB_COLUMNS    WHERE       COLUMN_NAME LIKE '%PATTERN%';

iphone courses online

iOS programming resources online ; 

http://teamtreehouse.com

http://itunes.apple.com/in/itunes-u/ipad-iphone-application-development/id473757255

for ios 5 : 

http://itunes.apple.com/in/itunes-u/developing-apps-for-ios-hd/id395605774

Enabling sudo on mac os/Enabling root user on mac os

http://www.spy-hill.com/~myers/help/apple/EnableRoot.html

who is locking whom oracle locks

select s1.username || '@' || s1.machine
|| ' ( SID=' || s1.sid || ' ) is blocking '
|| s2.username || '@' || s2.machine || ' ( SID=' || s2.sid || ' )
' AS blocking_status
from v$lock l1, v$session s1, v$lock l2, v$session s2
where s1.sid=l1.sid and s2.sid=l2.sid
and l1.BLOCK=1 and l2.request > 0
and l1.id1 = l2.id1
and l2.id2 = l2.id2 ;

Oracle alter table add or drop column

alter table supplier drop column supplier_id;

alter table
cust_table
add
cust_sex varchar2(1) NOT NULL;

Her is an example of Oracle "alter table" syntax to add multiple data columns.

ALTER TABLE
cust_table
ADD
(
cust_sex char(1) NOT NULL,
cust_credit_rating number
);