Shell Setting Notes

Turn on or off color syntax highlighting in vi or vim To turn on syntax highlighting in vi or vim, enter command below

:syntax on

To turn of color syntax highlighing , enter command below in vi or vum

:syntax off

You can edit ~/.vimrc file and add command syntax on to it so that next you will start vim with color syntax highlighting option

$ cd
$ vi .vimrc

Append the following line:

syntax on

SLES 11 Unlock An Account

To unlock an account in SLES 11 SP3
$ pam_tally2 --user=accountname --reset=0
$ faillog -u root -reset

Loại bỏ dấu tiếng Việt trong Oracle PL/SQL

CREATE OR REPLACE FUNCTION CONVERTTOUNSIGN(p_string VARCHAR2) RETURN VARCHAR2 AS BEGIN RETURN TRANSLATE(p_string, 'ăâđêôơưàảãạáằẳẵặắầẩẫậấèẻẽẹéềểễệếìỉĩịíòỏõọóồổỗộốờởỡợớùủũụúừửữựứỳỷỹỵýĂÂĐÊÔƠƯÀẢÃẠÁẰẲẴẶẮẦẨẪẬẤÈẺẼẸÉỀỂỄỆẾÌỈĨỊÍÒỎÕỌÓỒỔỖỘỐỜỞỠỢỚÙỦŨỤÚỪỬỮỰỨỲỶỸỴÝ', 'aadeoouaaaaaaaaaaaaaaaeeeeeeeeeeiiiiiooooooooooooooouuuuuuuuuuyyyyyAADEOOUAAAAAAAAAAAAAAAEEEEEEEEEEIIIIIOOOOOOOOOOOOOOOUUUUUUUUUUYYYYYDD'); END CONVERTTOUNSIGN;