Category: Oracle
Posted by: hajime osako
%uFF20IT%uFF1AOracle%u7BA1%u7406%u8005%u306E%u305F%u3081%u306ESQL%u30EA%u30D5%u30A1%u30EC%u30F3%u30B9

GRANT {system_privilege | ALL PRIVILEGES}
[, system_privilege ]
TO {user | role | PUBLIC} [, {user | role} ]
[IDENTIFIED BY password]
[WITH ADMIN OPTION];
Category: Oracle
Posted by: hajime osako
How can I find Table, Index and Column which are indexed? : Oracle FAQ - dbapool.com

select index_name , table_name , column_name from user_ind_columns order by table_name ;
Category: Web dev
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
Java - %u30B9%u30EC%u30C3%u30C9%u30C0%u30F3%u30D7%u306E%u53D6%u308A%u65B9 %u305D%u306E3 / Windows %u30B5%u30FC%u30D3%u30B9%u3068%u3057%u3066%u767B%u9332%u3057%u3066%u3044%u308B%u5834%u5408%u306F%uFF1F - %u4F8D%u30BA%u30E0

SendSignal [process ID]
http://www.latenighthacking.com/projects/2003/sendSignal/

StackTrace
http://www.adaptj.com/main/stacktrace

Web Logic:
%WL_HOME%\bin\beasvc -dump -svcname:[service name (ex: "beasvc mydomain_myservice")]
or from weblogic.admin (http://otndnld.oracle.co.jp/document/products/wls/docs81/admin_ref/cli.html)
Category: Linux tips
Posted by: hajime osako
RPM%u306B%u3088%u308B%u30D1%u30C3%u30B1%u30FC%u30B8%u7BA1%u7406%u3092%u7406%u89E3%u3059%u308B %uFF0D %uFF20IT%u81EA%u5206%u6226%u7565%u7814%u7A76%u6240

RPM data is stored under /var/lib/rpm as Berkeley DB file

rm /var/lib/rpm/__db.* ; rpm --rebuilddb

Using RPM to Verify Installed Packages

rpm -Va for all
or
rpm -Vp /mnt/cdrom/RedHat/RPMS/i386/adduser-1.1-1.i386.rpm


Category: Oracle
Posted by: hajime osako
Category: Web dev
Posted by: hajime osako
http://code.google.com/p/rst2pdf/

gcc required (from cygwin installer)

python setuptools required.
http://pypi.python.org/pypi/setuptools
download egg and "sh setuptools.xxxx.egg"

python setup.py install

http://bitbucket.org/javajuneau/jythonbook/
Category: Linux tips
Posted by: hajime osako
A type appended text append after the line
y for copy and p for paste
To repeat a motion prepend it with a number: 2w
To move to the start of the line use a zero: 0
CTRL-G displays your location in the file and the file status.
G moves to the end of the file.
gg moves to the first line.
Typing ? followed by a phrase searches BACKWARD for the phrase.
N to search in the opposite direction.
CTRL-O takes you back to older positions, CTRL-I to newer positions.
CTRL-W CTRL-W to switch current window
CTRL-W c to close crrent window, more infor :help windows
Typing % while the cursor is on a (,),[,],{, or } goes to its match.
To ask for confirmation each time add 'c' :%s/old/new/gc
:!command executes an external command.
v motion :w FILENAME saves the Visually selected lines in file FILENAME.
Ctrl-v^jjjI#[space][esc]
:r FILENAME retrieves disk file FILENAME and puts it below the cursor position.
CTRL-n or CTRL-p in insert mode is for auto-complete.
more infor :help ins-completion
Category: Web dev
Posted by: hajime osako
Category: MS tips
Posted by: hajime osako
/var/blog/: Change the keyboard layout to English later for Windows

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\i8042prt\Parameters]
"OverrideKeyboardSubtype"=dword:00000000
"OverrideKeyboardIdentifier"="PCAT_101KEY"
"LayerDriver JPN"="kbd101.dll"