Archive for May, 2009

Multimedia on jaunty

May 29, 2009 Leave a comment

Remix version of jaunty is very smooth has additional value on visual aspect. But, like earlier release of ubuntu, this version lack of multimedia support.

due to license of some codecs, ubuntu doesn’t include pupolar multimedia codecs for playing restricted file format such as mp3, mp4 even popular mpeg format.

to solve this problem, i use medibuntu (may be acronym for multiMEDIa uBUNTU) repository to install all codecs i need ….

the steps are:
1. Include this line to source.list file :
deb jaunty free non-free

2. get the key and add it to keyring
wget -q -O- | sudo apt-key add -

3. update the repository
sudo apt-get update

4. the last step is install your codecs
sudo apt-get install non-free-codecs

Categories: Uncategorized

Reset Sequence on Oracle

May 20, 2009 Leave a comment

as a programmer or dba which is using oracle as dbms backend, using sequence is pretty easy for generating sequence number which is similar as auto increment number on mysql.

but reseting this sequence number, is little tricky.
the easiest way to reset this sequence is alter the sequence syntax and use negative number as increment value to reduce the next value on that sequence. this negative number can be valued as we need.

this is the syntax :

alter sequence seq_name
increment by negative_value

Categories: Database