Perl: Epoch to date

perl -e 'print scalar gmtime 1404982047'
Thu Jul 10 08:47:27 2014

Set up Word 2010 / 2013 styles

If when re-opeing your doc, Word decided to turn your existing styles into shit (e.g. 3.4 became 1.49), start all the way from the start:

• Enable Developer menu: File | Options | Customize Ribbon then tick the Developer checkbox in the right hand side list
  
  
• Then in the new Developer menu, push the Document Template button, and untick the Automatically update document styles checkbox
  
• Then follow this tutorial: How to create numbered headings or outline numbering in Word

Blocked loading mixed active content

A workaroung in FF is:
Go to about:config
and
security.mixed_content.block_active_content = false

Javascript: force client to reload javascript files

Ctrl+F5

or add a version information in file specification, and change it every time the js file is updated

<script type="text/javascript" src="file.js?1.1"></script>

OSX: from 10.9.2 to 10.9.3

Install the OS X Mavericks 10.9.3 Update (Combo)
Use MultiBeast 6.3 with this conf.

Reboot, et voila:

XEmacs: show ^M (\r)

M-x find-file-literally /path/to/file

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+)/; }'

Oracle: select from list of values

select distinct column_value from table(sys.odcinumberlist(1,1,2,3,3,4,4,5));

or

select column_value from table(sys.dbms_debug_vc2coll('One', 'Two', 'Three', 'Four'));

ORA-01555: snapshot too old: rollback segment number 61 with name "_SYSSMU61_1706556987$" too small

SQL> select max(maxquerylen) from v$undostat;

26687

Add 20% to this value and update UNDO_RETENTION parameter.

SQL> ALTER SYSTEM SET UNDO_RETENTION = 32024;

Update CPAN perl packages

cpan upgrade /(.*)/

Mavericks 10.9.2: network lost after upgrade

Symptom: network stopped working suddenly after Mavericks upgrade
History:

1. Updated Mavericks to 10.9.2 using Combo update
2. Re-installed conf. using MultiBeast 6.2.1
3. Reboot
4. Network KO
5. Repair permissions: sudo diskutil repairPermissions /
6. Reboot

Oracle PL/SLQ: On Emulating FINALLY

On Emulating FINALLY by Steven Feuerstein

Oracle: monitoring long tasks

SELECT start_time, username, target, sofar blocks_read, totalwork total_blocks, round(time_remaining/60) minutes FROM v$session_longops WHERE sofar <> totalwork;

Oracle: remove duplicate records

Tom said: http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:15258974323143

Git tips from the trenches

https://ochronus.com/git-tips-from-the-trenches/#null

PL/SQL: how to deal with nullable variables in query

where decode(column, variable, 0) is not null