Archive for November, 2009

Older Entries

ORA-00942 Table or View Does Not Exist Oracle Error

In: Oracle

30 Nov 2009

Recently one of the webapps in UAT environment have trouble running one of the dayend job schedule. I try to go over the application log and notice Cause: java.sql.SQLException: ORA-00942: table or view does not exist Then I try to run the sql statement that the webapp trying to execute before hitting this error and [...]

2009 Macau Grand Prix

In: Leisure

27 Nov 2009

Bookmark It Hide Sites $$(‘div.d1376′).each( function(e) { e.visualEffect(‘slide_up’,{duration:0.5}) });

Show All Users in MySql

In: MySQL

26 Nov 2009

Today a colleague ask me how to obtain a full list of all users in a mysql database. The first thing come into my mind is SELECT * FROM all_users; Then I realize this is for oracle database only. The dilemma of using multiple database is sometimes you might get their syntax all mix up. [...]

Solving Windows Mobile WIFI Disconnect Problem

In: HTC

23 Nov 2009

Recently upgrade my HTC Diamond 2 to use the new Windows Mobile 6.5 but I discover that  WI-FI connection automaticly turns off when I put my device into standby and it won’t reconnect instantly after I had turned it back on. I had to go to comm manager and manually turn it on and off. [...]

Query All Tables

In: Oracle

23 Nov 2009

Recently I have to do some maintenance job on my client site and  I am force to do my work on console terminal. I am used to do my wrok on tools like Toad and SqlDeveloper where I can use the fency GUI and the AI of those tools. Now I have to dig up [...]

Select Count Using Grouping

In: Oracle

18 Nov 2009

Recently coming across a question regarding select count using grouping. Below is two sample tables TABLEA ID CHIP ———– ———- 1 Lays 1 Ruffles 1 Ruffles 1 Ruffles 1 Doritos 1 Doritos 2 Lays 2 Lays 2 Doritos 3 Ruffles TABLEB ID NAME ———– ———- 1 Jim 2 Bob 3 MISSY 4 Tom The query [...]

Oracle Savepoint

In: Oracle

13 Nov 2009

Recently was asked to amend some production data in database and test the production application reaction. So I need to take advantage of savepoint provided by oracle to make sure the amendment won’t screw up. A SAVEPOINT is a marker within a transaction that allows for a partial rollback. As changes are made in a [...]


Older Entries

About this blog

This is a place I create just for fun and to write down some experience and notes for myself. So feel free to enjoy and drop any comments you have. I had been employed as Programmer, System Analysts, System Administrator, DBA and Project Manager. I will share some of my case study here as well. Enjoy!

Categories

Archives

  • kc: great.. it solved my issue ... thnks a lot... :) [...]
  • mike: thank you so much. it helped solve my error. :) [...]
  • Wyatt Richardson: I'm pretty much impressed with the stability of Windows 7. It is better than windows Vista which hog [...]
  • Ellie Hughes: Playstation is the best gaming console that i have owned. Me and my brother are addicted in playing [...]
  • Eric Patterson: I have tried using Chrome OS in one of my desktop PC's, the overall performance is above average to [...]

 

Calendar

November 2009
M T W T F S S
« Oct   Dec »
 1
2345678
9101112131415
16171819202122
23242526272829
30  

Copyright © 2007 - Vpire Blog - is proudly powered by WordPress | Log in