Oct 20, 2007

Create Procedure

Procedure:
create or replace procedure hello is
begin
DBMS_OUTPUT.PUT_LINE('hello');
end hello;
Call:
SET SERVEROUTPUT ON;
begin
hello;
end;
/

Oct 19, 2007

Connect to SQL*PLUS

C\:>sqlplus
input username, password
or run
SQL commandline from Oracle menu.
Simple SQL:
SQL>select * from table;
Simple PL/SQL:
SQL>SET SERVEROUTPUT ON;
2 BEGIN
3 DBMS_OUTPUT.PUT_LINE('hello');
4 END;
5 /

Oct 12, 2007

Proxy

Download proxy from
http://sourceforge.net/projects/proxy/
Installation
$ tar xzvf proxy.tar.gz
$ cd proxy
$ make
$ ./proxy -s 8080 -S 192.168.1.39 -d 80 -D nhungnguoibantot.net

Oct 9, 2007

Delete Linux User

Using to find user's files
Firstly
$ find / -user username
Manually delete or
$ find / -user username > log.txt
$ rm -rf `cat log.txt`
Finally
$ userdel username

Using iMacros to interactive with browser

Using iMacros add-on to interactive with brownser: automatically input text, redirect...
https://addons.mozilla.org/ja/firefox/addon/3863
very useful for page with many input boxs, many times access.

Oct 3, 2007

Text based browser

In Linux
Installation
$ yum install w3m
Running
$ w3m http://google.com

Tiếng việt trên Fedora

Sử dụng scim cho nhu cầu soạn thảo tiếng việt trên linux
$ yum install scim scim-m17n m17n-db m17n-lib m17n-db-vietnamese
$ cd /usr/share/m17n
$ wget http://vnlinux.org/vi-telex.mim

Oct 2, 2007

Decompress CHM

Using archmage to convert ebook from CHM format to html format
$ yum -y install archmage
$ archmage file.chm directory