This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Excelでシート名一覧を取得するワンライナー | |
For Each i In ThisWorkbook.Sheets: debug.print i.name : next i |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub RemoveLink() | |
Dim wb As Workbook | |
Set wb = Application.ActiveWorkbook | |
If Not IsEmpty(wb.LinkSources(xlExcelLinks)) Then | |
For Each link In wb.LinkSources(xlExcelLinks) | |
wb.BreakLink link, xlLinkTypeExcelLinks | |
Next link | |
End If | |
End Sub |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Memory Segmentation Cheat Sheet |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Oracleのスキーマをコピーするスクリプト | |
(実際に動作するかは試していない) | |
create user [DEST_SCHEMA] identified by [DEST_SCHEMA] default tablespace USERS temporary tablespace TEMP profile DEFAULT; | |
grant create session,create table,create view,create sequence,create trigger,create synonym,unlimited tablespace to [DEST_SCHEMA]; | |
expdp system/manager SCHEMAS=[SRC_SCHEMA] DIRECTORY=DATA_PUMP_DIR DUMPFILE=[SRC_SCHEMA].dmp | |
impdp system/manager DIRECTORY=DATA_PUMP_DIR DUMPFILE=[SRC_SCHEMA].dmp REMAP_SCHEMA=[SRC_SCHEMA]:[DEST_SCHEMA] |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
左辺と右辺を交換する正規表現 | |
検索文字列 | |
([ \t]*)(.*[^ ])([ ]*=[ ]*)(.*[^ ])(;) | |
置換文字列 | |
\1\4\3\2\5 | |
説明 | |
()でグループ化した文字列を、置換文字列で入れ替えする仕組み。 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# yum install gcc gcc-c++ make openssl-devel | |
# yum wget | |
# wget ftp://ftp.delegate.org/pub/DeleGate/delegate9.9.7.tar.gz | |
# tar zxvf delegate9.9.7.tar.gz | |
# cd delegate9.9.7 | |
# make | |
(途中で管理者宛のメールアドレスを聞かれるので入力してEnterを押す) | |
# cp src/delegated /usr/local/sbin/ | |
# ln /usr/local/sbin/delegated /usr/sbin/delegated | |
# mkdir /etc/delegate |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
1.log4j.propertiesをClassPathの通っている場所に配置する | |
2.JVMオプションで指定する | |
-Dlog4j.configuration=file:///c/conf/log4j.properties | |
3.プログラムからPropertyConfigurator.configureを使用して設定する。 | |
import org.apache.log4j.PropertyConfigurator; | |
PropertyConfigurator.configure(replacedPath); | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Windows | |
-Dlog4j.configuration=file:///c/user/log4j.properties | |
Linux | |
-Dlog4j.configuration=/home/user/log4j.properties |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
usermod username -a -G sudo |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
あらかじめrsyncサーバを構築しておく。rsyncクライアントはUbuntuにデフォルトでインストールされている | |
https://help.ubuntu.com/community/rsync | |
rsync -azvv --delete shell/ user@hostname::shell/ | |
windowsからcwrsync経由でrsyncするときはコピー元をcygwin形式で記述 | |
c:\build\フォルダの場合は、/cygdrive/c/build/ |
NewerOlder