Remove the firefox browsing history

1. In the Location bar, enter about:config
2. Search for the preference browser.urlbar.maxRichResults.
3. Double-click the browser.urlbar.maxRichResults preference and enter a value of -1.
4. Close Firefox.
5. Start Firefox again.

Now when you type in the Location bar, no list of results will be shown.

Source: http://www.raymond.cc/blog/archives/2006/11/14/how-to-delete-individual-urls-from-firefox-address-bar-history/

SQLPLUS prompt

I got my PC refreshed the other day. Lost most of my settings and didn't have a good backup though have been backup up files here and there, throwing here..form disk A to disk B...at the end when disaster strike...can't really manage to handle.

Anyway, visit http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-06-22.9332221251

It has a good write up on SQLPLus prompt customization.

My sample and favorite as below

COLUMN file_name FORMAT a44
COLUMN tablespace_name FORMAT a20
COLUMN owner FORMAT a15
COLUMN segment_name FORMAT a20
set lines 132
set pages 100
set termout off
col dbname new_value prompt_dbname
col uname new_value prompt_username

select instance_name dbname from v$instance;
select user uname from dual;
set sqlprompt "&&prompt_username'@'&&prompt_dbname> "
set termout on
set time off

Error 5004 to use alter database, the database must be in a writable state in which a checkpoint can be executed in sql server 2000

Try detach/attach the database mentioned

One of the nice travel blogs that I like for Bangkok

Probably the fact the same hotel that I stayed caught my first attention.