programaker

NSString* someString = @"FooBar";
BOOL someStringContainsFoo = ([someString rangeOfString: @"Foo"].location != NSNotFound);

programaker

cat /etc/lsb-release

programaker

select * from all_tab_columns where table_name = 'TABLE_NAME';

programaker

select 
    varchar_field, length(varchar_field) 
from 
    table_name 
where
    length(varchar_field) in (
        select max(length(varchar_field)) from table_name
    )

programaker

select * from all_constraints where table_name = '<table_name>'

-- where constraint_type = 'P' -> primary key
--                       = 'R' -> foreign keys
--                       = 'C' -> constraints like not null

programaker

select * from all_sequences;

programaker

select 
    cols.table_name, 
    cols.column_name, 
    cols.position, 
    cons.status, 
    cons.owner
from 
    all_constraints cons inner join all_cons_columns cols on
        cons.constraint_name = cols.constraint_name and
        cons.owner = cols.owner

programaker

NSURL* url = [[NSURL alloc] initWithString: @"http://www.cnn.com"];
[[UIApplication sharedApplication] openURL: url];

programaker

# swappiness controls the intensity of swap use, varying between 0 and 100
# this command modifies the swappiness in runtime, but the change won't persist after shutdown
sudo sysctl -w vm.swappiness=0

programaker

# to change the default folder locations in ubuntu,
# just edit this file, following the instruction inside it
vi $HOME/.config/user-dirs.dirs