csv出力

select * 
from tablename
into outfile 'c:\\data.csv' 
fields terminated by ',' 
optionally enclosed by '"';

文字コードに関するシステム変数

show variables like 'character\_set\_%';

文字コードを調べる

select
  value 
from 
  nls_database_parameters 
where 
  parameter='NLS_CHARACTERSET';

profile 読み込み

source .bash_profile

部分文字列を取り出す

private String getCutString(String str, String start, String end) throws Exception {
  String rtnStr = "";

  int pos1, pos2;
  pos1 = str.indexOf(start);
  if (!end.equals("")) {
    pos2 = str.indexOf(end, pos1);
    rtnStr = str.substring(pos1 + start.length(), pos2);
  } else {
    rtnStr = str.substring(pos1 + start.length());
  }

  return rtnStr;
}