sqlplus tip

1. DEFINE_EDITOR=vi  - define the vi editor
2. EDIT - edit the sql statement in current buffer with using vi editor
3. save file <filename> - save the sql statement in current buffer to a file
4. get file <filename> - load the sql statement from file to current buffer
5. / - execute the sql statement in current buffer

Some tools

Ganglia - a tools to monitor the system performance

http://ganglia.info/

Hudson - A tools to perform the build and automation functional test

http://hudson.com/

nmon - a tools to monitor the Linux performance

http://blog.csdn.net/chinalinuxzend/archive/2009/06/03/4238526.aspx

Selenium - a tool to do the web automation test

http://seleniumhq.org/

Some sql tips

sequence and streams

CREATE SEQUENCE some_sequence
  START WITH -1
  INCREMENT BY -100

Convert the delimited string to list

select (column_value).getstringval()
from xmltable('"a","b","c"');