Monday, May 24, 2010

how to get table create script in oracle

SQL> SET LONG 9999999
SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','TEST') FROM DUAL;

Monday, May 3, 2010

chat command with skype

On a conversation window, you should try:

/help

And you will see a help like this:

[11:49:39 PM] System: Available commands:
 /me [text]
 /topic [text]
 /add [skypename]
 /history
 /find [text]
 /fa or /
 /alertson [text]
 /alertsoff
 /call [skypename] ..
 /leave
 /goadmin
 /get creator
 /get role
 /whois [skypename]
 /setrole [skypename] MASTER|HELPER|USER|LISTENER
 /kick [skypename]
 /kickban [skypename]
 /get uri
 /get guidelines
 /get xguidelines
 /set guidelines [text]
 /get options
 /set options [[+|-]flag] ..
 /setpassword [password] [password hint]
 /clearpassword
 /get password_hint
 /get banlist
 /get allowlist
 /set banlist [[+|-]mask] ..
 /set allowlist [[+|-]mask] ..
 /help

Fun?  Hehehhe.  Many commands just like IRC

cannot install audacity with error about pdns (powerdns)

For some reason, the script to install audacity in debian has to be able to stop pdns successfully... (I know this is weird).  So, what you need to do is to start it first by:

# /etc/init.d/pdns_recursor start
# apt-get install audacity

converting .mp4 to mp3

$ mplayer -ao pcm in.mp4 -ao pcm:file="out.wav"
$ lame out.wav