Oracle: Caching techniques to call functions in queries

Efficient Function Calls From SQL

HTC Pico/Explorer: Extend external memory after CM10.2 install

Use this link to download MiniTool Partition Wizard Home Edition

http://download.cnet.com/MiniTool-Partition-Wizard-Home-Edition/3000-2094_4-10962200.html?part=dl-6285158&subj=dl&tag=button

1. Connect your SD card to PC through USB mode
2. Run the downloaded file (pwhe8.exe)
3. Select your SD card 2nd partition and right click to select DELETE option
4. Again select your 2nd partition (unallocated space at this moment) and right click to select CREATE option
5. Select partition type as ext4 and drive as primary (Not logical) from popup window
6. At last select the apply button from tool bar (first button)

Done - you created a EXT4 partition

 Then install Mounts2Sd from Google Play, then
1. After installing the app, open it and allow root access
2. Configure install script
3. Enable applications, data , cache, etc.
4. Reboot

Oracle: Stop a datapump job run via crontab

Show datapump jobs

select * from dba_datapump_jobs;

Stop a datapump job

DECLARE
   handle NUMBER;
BEGIN
    -- Format: DBMS_DATAPUMP.attach('[job_name]','[owner_name]');
    handle := DBMS_DATAPUMP.attach('SYS_EXPORT_FULL_02','SYSTEM');
    DBMS_DATAPUMP.STOP_JOB(handle, 1, 0);
END;

Perl md5

perl -MDigest::MD5 -e 'print Digest::MD5::md5_hex("mbqt")'

Use quotes in a perl one-liner

 cat /media/host/vbox.txt | perl -e 'while (<>) { print "'"'"'$1'"'"',\n" if /^(\d+)/; }'