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

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

Find the blocking session port, and then kill the process listening on that port.

SELECT O.OBJECT_NAME, S.SID, S.SERIAL#, P.SPID, S.PROGRAM,S.USERNAME,
S.MACHINE,S.PORT , S.LOGON_TIME,SQ.SQL_FULLTEXT 
FROM V$LOCKED_OBJECT L, DBA_OBJECTS O, V$SESSION S, 
V$PROCESS P, V$SQL SQ 
WHERE L.OBJECT_ID = O.OBJECT_ID 
AND L.SESSION_ID = S.SID AND S.PADDR = P.ADDR 
AND S.SQL_ADDRESS = SQ.ADDRESS;

[root@dwh1 ~]# netstat -ap | grep 22735
tcp        1      0 dwh1.prod.mbqt:ncube-lm     dwh1.prod.mbqt:22735        CLOSE_WAIT  19050/oracledwhmbqt 

[root@dwh1 ~]# kill -9 19050

VirtualBox: force guest IP address

> sudo vi /etc/sysconfig/network-scripts/ifcfg-eth0

DEVICE=eth0
HWADDR=08:00:27:B5:56:05
NM_CONTROLLED=no
ONBOOT=yes
BOOTPROTO=static
#IPADDR=192.168.2.8
IPADDR=192.168.1.101
NETMASK=255.255.255.0
TYPE=Ethernet
DNS1=8.8.8.8
DNS2=8.8.4.4

Then restart network

> sudo service network restart

Bulk Processing with BULK COLLECT and FORALL

Oracle magazine article by Steven Feuerstein

/usr/bin/perl^M: bad interpreter

One perlish way to fix this:

>./fm_test.pl
-bash: ./fm_test.pl: /usr/bin/perl^M: bad interpreter: No such file or directory

is:

> perl -pi -e 'tr[\r][]d' ./fm_test.pl

Another way is to use dos2unix

Compute files size

find . -name "*" -ls | awk '{total += $7} END {print total}'

Vim backspace issue

If backspace leaves ^? in vim, this is most probably because of "stty erase ^H" being present either in your .bashrc or .bash_profile.
Remove it and Vim will be happy with backspace.

Oracle: ORA-14402: updating partition key column would cause a partition change

This can be circumvented with:

ALTER TABLE my_table ENABLE ROW MOVEMENT;

CyanogenMod 10.2 on HTC Explorer

• How To Root HTC Explorer Pico and Install CWM Recovery
• CyanogenMod 10.2 Weekly Builds
• Install Jelly Bean 4.3 Based CyanogenMod 10.2 Nightly Build ROM on HTC Explorer/Pico
• How To Increase Your HTC Pico's Internal Memory Using Link2SD

Perl: sort hash values by keys

my @sorted_values = @hash{sort {$a <=> $b} keys %hash};

Oracle: aggregate data from a number of rows into a single row

Base Data:

    DEPTNO ENAME
---------- ----------
        20 SMITH
        30 ALLEN
        30 WARD
        20 JONES
        30 MARTIN
        30 BLAKE
        10 CLARK
        20 SCOTT
        10 KING
        30 TURNER
        20 ADAMS
        30 JAMES
        20 FORD
        10 MILLER

SELECT deptno, LISTAGG(ename, ',') WITHIN GROUP (ORDER BY ename) AS employees
FROM   emp
GROUP BY deptno;

    DEPTNO EMPLOYEES
---------- --------------------------------------------------
        10 CLARK,KING,MILLER
        20 ADAMS,FORD,JONES,SCOTT,SMITH
        30 ALLEN,BLAKE,JAMES,MARTIN,TURNER,WARD

jQuery: Have UI datetimepicker 'Now' button use UTC time?

This solution requires an update of the source code:
http://stackoverflow.com/a/17833188/732797