Oracle NLS-Lang Settings
13-Aug-10To 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
Oracle: Drop table if exists replacement
16-Feb-10Mysql has a nice “if exists” addition to the drop table statement. If the table to be dropped does not exists, it doesn’t raise an exception but only creates a warning. In Oracle RDMBS you can emulate this behavior like so: BEGIN EXECUTE immediate ‘drop table INSERT_TABLE_NAME_HERE’; EXCEPTION WHEN others THEN IF SQLCODE != -942 […]
Different day, same shit, today: Java 5 on Oracle Enterprise Linux 5
19-Jan-09Worlds collide: Oracle and Sun JDK. Perfect start to ruin a not so bad Monday morning. Background: Need to have a Tomcat Server deployed on a Oracle Enterprise Linux 5 system. I was happy, when i saw a tomcat5 package in the repositories. Great, i thought. All i need. Well. Not. Under Windows you’ll get […]
RFC3339 revisited
13-Nov-08Not just for ruby but also the corresponding formats for Java public static final SimpleDateFormat RFC3339_FORMAT = new SimpleDateFormat("yyyy-MM-dd’T’HH:mm:ssZ");public static final SimpleDateFormat RFC3339_FORMAT = new SimpleDateFormat("yyyy-MM-dd’T’HH:mm:ssZ"); and for Oracle SELECT to_timestamp_tz(’1979-21-09T06:54:00+01:00′,’YYYY-MM-DD"T"HH24:MI:SSTZH:TZM’) FROM dual /select to_timestamp_tz(‘1979-21-09T06:54:00+01:00′,’YYYY-MM-DD"T"HH24:MI:SSTZH:TZM’) from dual / Oracle
Fun with sql
27-Oct-08What’s all the fuss about this SQL Injection thing? It boils down getting some malicious crafted SQL code into the SQL code of an application, destroying data or authenticate yourself without knowing any real password. xkdc has a nice explanation. The simple cases base on wrong escaped strings and the like. But as this SQL […]