Oracle remove double / multiple spaces
SELECT TRIM(REGEXP_REPLACE(<str>,’ +’,’ ‘)) AS compressed_str FROM <TABLE>
Author: admin
Unix XML parser xmllint
http://www.tutorialspoint.com/unix_commands/xmllint.htm
Get oracle table size
http://stackoverflow.com/questions/264914/how-do-i-calculate-tables-size-in-oracle –first gather stats for table… begin dbms_stats.gather_table_stats(‘MYSCHEMA’,’MYTABLE’); end; –or schema… begin dbms_stats.gather_table_stats(‘MYSCHEMA’); end; –get table size select owner, table_name, round((num_rows*avg_row_len)/(1024*1024)) MB, num_rows, avg_row_len, last_analyzed from all_tables where owner = ‘<WHOEVER>’ and table_name in (‘<WHATEVER>’) order by MB desc Also …
ORACLE PL/SQL procedure permissions
Issue: Trying to issue an EXECUTE IMMEDIATE command from within a PL/SQL procedure and geting: ORA-01031: insufficient privileges while issuing an EXECUTE IMMEDIATE. The same EXECUTE IMMEDIATE command works from within an anonymous PL/SQL block. The procedure and the anonymous block …
SCP
scp <LOCAL_FILENAME_PATTERN> <REMOTE_USER>@<REMOTE_SERVER>:<REMOTE_DIRECTORY>
Parallel INROWNUM
(@INROWNUM – 1) * @NUMPARTITIONS + @PARTITIONNUM + 1
Parallel Materialized Views
Click to access MV_Refresh_Parallel.pdf
orchadmin
[server1:~]: export DSHOME=$(cat /.dshome) [server1:~]: . $DSHOME/dsenv [server1:~]: export LD_LIBRARY_PATH=$APT_ORCHHOME/lib [server1:~]: export APT_CONFIG_FILE=/opt2/IBM/InformationServer/Server/PXEngine/APT_GRID_JOBDIR/ADM_00_ACCOUNT_SUMMARY_Master_Daily_SEQ/ADM_00_ACCOUNT_SUMMARY_Master_Daily_SEQ_32899132.config.apt [server1:~]: export PATH=$DSHOME/bin:$APT_ORCHHOME/bin:/$PATH [server1:~]: orchadmin -help ##I IIS-DSEE-TFCN-00001 16:53:40(000) <main_program> IBM InfoSphere DataStage Enterprise Edition 8.7.0.6366 Copyright (c) 2001, 2005-2011 IBM Corporation. All rights reserved ##I …
Unix mass file rename
for filename in <FILENAME_PATTERN>; do echo mv \”$filename\” \”${filename//<STRING_TO_REPLACE>/<REPLACEMENT_STRING>}\”; done | /bin/bash E.g: for filename in linx*; do echo mv \”$filename\” \”${filename//20140430/20140508}\”; done | /bin/bash
PLOG debugging package
http://log4plsql.sourceforge.net/docs/UserGuideDOC.html