removing annonying issues over telnet/rlogin/sqlplus

You can use stty command to map a unmapped key to a action using stty. For example,
stty erase ^H

Maps backspace to erase action. in the same way you can also assign actions for other keys and it should work. Checkout man page of stty for more information. :)

group_concat functionality in Oracle

some time back I was searching for this query, but couldn't get it. While searching for some
other stuff I got this link
http://www.orafaq.com/forum/m/135323/43055/?srch=concat_all#msg_135323

SQL> select d.dname
2 , NVL(concat_all(concat_expr(e.ename,',')),'None') enames
3 from emp e
4 , dept d
5 where e.deptno(+) = d.deptno
6 group by d.dname
7 /

DNAME ENAMES
-------------- --------------------------------------------------
ACCOUNTING CLARK,KING,MILLER
OPERATIONS None
RESEARCH SMITH,JONES,SCOTT,ADAMS,FORD
SALES ALLEN,MARTIN,TURNER,WARD,JAMES,BLAKE



and this
http://halisway.blogspot.com/2006/08/oracle-groupconcat-updated-again.html

with data
as
(
select job,
ename,
row_number() over (partition by job order by ename) rn,
count(*) over (partition by job) cnt
from emp
)
select job, ltrim(sys_connect_by_path(ename,','),',') scbp
from data
where rn = cnt
start with rn = 1
connect by prior job = job and prior rn = rn-1
order by job
/

Writing extensions for firefox and thunderbird

Anybody who is interested in writing extensions for thunderbird or firefox can use
http://www.xulplanet.com/ site for getting started with the concepts and stuff.
It contains great resources for starters.

But, I feel like, site is not updated to the recent version. Goto Firefox site developer corner
to get more up to date info.

Enjoy!!!!

PowerSaving in Linux

For a long time I was looking for a site which guides me about tuning Linux for saving power on my
laptop. Cause my laptop emits more heat when under Linux compared to windows. I found this when going through Linux journal site.

Looks like this is going to solve the heating up issue, lets see.

Tunneling all services over HTTP proxy!!!

I found this link, from Manu's blog. A couple of days back I was wondered if there is any such software available, which can be used to tunnel every port over http proxy. I found it here. I most probably need this after sometime, so putting it here.

This is how I found it:
http://manugarg.blogspot.com/
|
V
http://del.icio.us/tag/hacking
|
V
http://www.nocrew.org/software/httptunnel.html from

Thanks Manu Garg!!
Happy Hacking

For people who don't know how to play any musical instrument

Don't worry guys, for people like us there are tons of softwares to help us make our own music. The one which I like the most is Fruity Loops. A great music creator with almost all features. You can even use this for giving sounds for your own home made movie.

Check this tutorial out, its good:
http://www.ultimate-guitar.com/columns/the_guide_to/fruity_loops_tutorial_part_1.html

Have a great time learning all the music instruments in one shot!!!!!!!!!!!!!

Using multimedia keys on your laptop

Multimedia keys that are available on you Laptop may not work out of box in Linux. In order to make it work you can use "xmodmap" command. For this you have to write a configuration file with all your keyboards scan codes and actions associated with the keys.

Check this link for more info:
http://ubuntuforums.org/showthread.php?t=12159&highlight=xmodmap+laptop
https://www.ubuntulinux.org/wiki/MultimediaKeys

Frets on Fire

For those who are learning Guitar, here is a good software or rather a game which could help in improving you guitar timing. Just download Frets on Fire game from http://fretsonfire.sourceforge.net/ and use your computer keyboard as your temporary guitar. The game is a open source project and is available for windows and Linux.

And to my absolute amazement it is written using Python!!!!!!!
Enjoy the game!!!!!!

Windows and Fonts in Linux

Most of the pages available on the Internet are designed for windows platform and they use Fonts available on windows. Because of this you might not be able to view the webpage as intended by the web developer. To overcome this just copy fonts from windows(available at c:\winnt\fonts) and copy them into ".fonts" directory in your home(/home/user/.fonts/). Restart your X-server and Viola you can see web pages which use windows fonts.

This is not the only request, if you want your Unicode/UTF8 pages to be rendered properly you need these fonts.

Happy Browsing!!!!!!!

Ubuntu / Debian based issues

A great place to get your linux issues resolved is to get started with searching in
http://ubuntuforums.org/ instead of google.

Esnips mp3 or flv(works on other files as well) download trick

Esnips is a great place to look for mp3's and other documents. If you want to download mp3 you will not be allowed to do so, cause it just starts playing with the embedded player.
In the address bar you will be seeing the address like this:
http://www.esnips.com/doc/7b95af4a-e608-44b0-9d3c-7a987863a6d2/Happy-Days
To download the mp3
just change /doc/ to /nsdoc/ and remove /Happy-Days and press enter, For ex:
http://www.esnips.com/nsdoc/7b95af4a-e608-44b0-9d3c-7a987863a6d2

This works for flv and other types of files as well.
Enjoy!!!!!!!!!

Downloading youtube videos in Linux

Couple of days back, when I was searching for some files that I created in temp directory, I accidentally found some files which start with name "Flash*" after issuing "ls -lrt" command. And when I played them in mplayer I could see all video that was just viewing in my firefox window.
So to download the youtube video all you have to do is copy this file to some other name and then close the firefox window. Enjoy the tweak!!!!!!

My youtube videos

http://www.youtube.com/watch?v=9V2hf_riyqY
http://www.youtube.com/watch?v=e0NMuWCEhTo

My Info

My Homepage http://naveen.wikidot.com
Family Hierarchy can be found at http://naveenreddy.tribalpages.com/

Snapfish.com now in India

Snapfish is an online digital photo printing service company started by hp. If you register within November 15, you will get 20 free photo's printed for free!!! So hurry up and register.

Testing Google Photo Preview

Google Web Albums

I had a couple of photos to be uploaded into Google photos. I thought of using Picasa Linux version, so that I can upload photos in bulk, but it does not support this yet. So I'm manually uploading all photos. :(

These photos are available at http://picasaweb.google.com/naveen.hn/AtTheFarm

Photo Shots taken using Sony DSC H9 Digital Camera

Couple of days back I took some shots with my new Camera, photos are available at http://www.esnips.com/web/naveenhnr-pics

Searching for a tool which can convert my video into a flv, so that uploading a video into youtube does not take more time. ffmpeg command came handy for me.
Command used:
ffmpeg -i mov00326.mpg -ar 22050 -ab 56 -aspect 4:3 -b 200 -r 12 -s 320x240 test.flv
Note: Sound was not working after converting, but its Okay for me as of now.