All posts in 'Shortcuts'

Oracle NLS-Lang Settings


To use SQL*Plus Windows correctly, export NLS_LANG like so: set NLS_LANG=GERMAN_GERMANY.WE8MSWIN1252 If you prefer the command line client SQL*Plus, export NLS_LANG like so: set NLS_LANG=GERMAN_GERMANY.WE8PC850

Read the complete article »

Using SQL*Plus without tnsnames.ora


As often, a quick reminder for me. I’m using the Oracle Instaclient on my Mac without a tnsnames.ora and i keep forgetting the connectstring syntax: sqlplus USER/PASS@//HOST:PORT/SIDsqlplus USER/PASS@//HOST:PORT/SID Extra bonus points: Through in rlwrap to get a nice commandline history and completion as used to in a standard shell: rlwrap sqlplus USER/PASS@//HOST:PORT/SIDrlwrap sqlplus USER/PASS@//HOST:PORT/SID

Read the complete article »

SVN: Revert to previous version


Just a quick reminder: To revert a complete working copy or a single file use: svn merge -rHEAD:PREV . # or svn merge -rHEAD:PREV path/to/file svn commit -m "reverted"svn merge -rHEAD:PREV . # or svn merge -rHEAD:PREV path/to/file svn commit -m "reverted"

Read the complete article »

Batchconvert ascii to utf8


Next time i see umlauts in source, I’ll scream. Loud. In the mean time I try this: find . -iname "*.java" -exec sh -c ‘iconv -f cp1252 -t utf-8 {} > {}.utf8’ \; for i in `(find . -name "*.utf8")`; do mv $i ${i/.utf8/}; donefind . -iname "*.java" -exec sh -c ‘iconv -f cp1252 -t […]

Read the complete article »

XML / XSD Schema validation on Mac OS X


I found no fancy graphical xml validator on OS X, but this isn’t a problem. OS X includes libxml which comes with xmllint. To validate a xml file against a schema: xmllint –noout –schema sitemap.xsd sitemap.xmlxmllint –noout –schema sitemap.xsd sitemap.xml

Read the complete article »