Notepad++ shortcuts

Shortcuts

View table info in Oracle

select * from dba_tables

View queries in Oracle

select * from v$sql

Triangle

A = 0.5 * (b * h)

Circle

d = 2 * r
C = 2 * pi * r
A = pi * r^2

Linux symbolic link

ln -s [source] [target]

Parse date in batch file

@For /F "tokens=2,3,4 delims=/ " %%A in ('Date /t') do @(
Set Month=%%A
Set Day=%%B
Set Year=%%C
)

@echo DAY = %Day%
@echo Month = %Month%
@echo Year = %Year%

window.Open

Window names cannot contain spaces in "window.open" scripts for IE

MySQL string replace

select replace([column], 'replace_this', 'with_that') from [table]