Skip to content

Instantly share code, notes, and snippets.

@yoshikaw

yoshikaw/wareki_sqlplus.sh

Created October 31, 2017 16:26
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yoshikaw/480d7783dbf2e4ac0a1d8aaba1cf5cbb to your computer and use it in GitHub Desktop.
Save yoshikaw/480d7783dbf2e4ac0a1d8aaba1cf5cbb to your computer and use it in GitHub Desktop.
Download ZIP
Raw
wareki_sqlplus.sh
echo -n 1989-01-0{7,8} $(date +%Y-%m-%d) | xargs -d\ -I@ echo -e "set pages 0 feedback off\nselect to_char(to_date('@', 'YYYY-MM-DD'), 'EEYY\"年 \"', 'nls_calendar=''Japanese Imperial''') || '@' from dual;" | NLS_LANG=American_America.AL32UTF8 sqlplus -S / as sysdba
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment