Viewing a Refcursor in TOAD

Run a PL/SQL block in the SQL editor as follows:<br />declare<br />begin<br /> OPEN :pv_cur FOR 'select * from dual';<br />end;<br /><br />Or if you have a function returning a refcursor<br /><br />declare<br />BEGIN<br /> :pv_cur := function_name(param1,param_etc);<br />END;<br /><br />TOAD will prompt you for the datatype/value of ':pv_cur'. <br />Change the type to 'Cursor' and leave the value blank, hit OK. <br />The ref cursor will be displayed in the standard data grid below, as if you had run a query.<br /><br /><br />

New database for crowd

Tough to find this one as its not in the install directories /var/opt/atlassian-crowd-home/crowd.cfg.xml See also http://confluence.atlassian.com/display/CROWD/Important+Directories+and+Files

Oracle: Checking a column is numeric

select * from table1 where ltrim(rtrim(translate(col1,'0123456789-.',' '))) is not null

Perl one-liner to summarise file volumes by hour

ls -l /u02/volestlivelogs01/oradata/ESTDB/archive/*.dbf | sed -e "s/:/ /g" -e "s/  / /g" | perl -lane 'BEGIN {%hash=();} $hash{"$F[5]$F[6]-$F[7]:00"}+= $F[4]; END {foreach $k (sort keys %hash) {print "$k " . int($hash{$k}/(1024*1024)) . " Mb"; } }'

Lost msconfig.exe

The location is not in the path - rather it is held in a registry key Create a .reg file with the following contents Windows Registry Editor Version 5.00 [HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\App Paths\MSCONFIG.EXE] @="C:\\WINDOWS\\PCHealth\\HelpCtr\\Binaries\\MSConfig.exe"