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
);

Oracle add or drop primary key

ALTER TABLE supplier
add CONSTRAINT supplier_pk PRIMARY KEY (supplier_id);

ALTER TABLE supplier
drop CONSTRAINT supplier_pk;

Installing XCode/IOS Simulator on Mac OS 10.6.1

First you need to upgrade your Mac OS.
Click on the Apple Icon -> Software Update and follow the instructions.
In my case it downloaded 1.33GB of updates.
First time it wasn't downloaded correctly so it asked me to download again.
I did that and restarted and I had been moved to Mac OS 10.6.8.

Then I installed the .dmg file for iOS SDK(4 GB). Instructions.
So, in all, I ended up downloading 7GB of data just to install XCode on my MAC. Amazing !