SQL statement of the month of JAN/2006

How to find a field with space in between? Use the following SQL statement:

Find nama negeri with Gap or space.


1 select decode(translate(nama_negeri,' ',nama_negeri),
2 nama_negeri, 'not found', 'found') found_or_not, nama_negeri
3 from neg
4 where decode(translate(nama_negeri,' ',nama_negeri),
5* nama_negeri, 'not found', 'found') = 'found'
SQL> /

FOUND_OR_ NAMA_NEGERI
--------- --------------------
found WP KUALA LUMPUR
found Luar Negara
found WP LABUAN

Work and Customers

Z got chicken pox since last week. His organization has been my client since 1997. He want me to run yearly batch job today with S, but when I show up in his office here, S is in clinic and have to wait till lunch time for her to come back.
You want to finish the task that assign to you but is all this hassels, they are interrupting you everyday! How to overcome all this?

Toastmaster Meeting 23/01/2006

Just attended Toastmaster meeting last nite.

Y.N talked about "buying a house". Notice Y.N. is more confident now when delivering her speech. Her strength is she got a friendly smile and nice voice. I believe she can become a good speaker. But she tend to put too much on her speech, speak too fast and memorise her speech. She should just maintain 3 points, slow down a bit and try to be passion in her speech. She also should put some stories in her speech, like describing how she should stay near her parent house so she can get free meal :) (Late come home, lazy prepare dinner, catch up with Astro TV programs, etc.)
She talk about budgeting also. She can use another item to represent the value of the house, for example: "I need the money of equivalent to buy 6 kancils, that's about $200K to buy a house."
Look forward to her next one.

J did a very dangerous but bold speech. He try to get feedback from the audience, by asking us "Do we believe in God". Bold because his 2nd speech in a foreign club. Dangerous because he may get audience who may like to heckle (try to annoy or embarrass) him, especailly he's talking about sensitive issue about God!

MAIC** Toastmaster Club level Speech contest

Went to MAIC** Toastmaster Club level Speech contest last Thursday. V is the winner. He's a well-balanced speaker, all the while. He had a freindly voice, smooth gestures and convincing deliverance. Cannot find out his weakness yet. He deserve to be the club's champion.

J* delivered a strong message. I belive she can deliver a message well with her personality. She has a tough and strong personality, and she definitely making use of that, her personality definitely give her the extra punch. Can see her holding her fist while delivering! In my own opinion, one weakness I found from her is she tend to only gestures more to her left.
She is addressing more to the left. I belive she should spread her 'gestures' to the entire room. Her choice of words are a bit technical.

Y* is a down to earth speaker. Just listen to him is like listen to some light-and-easy radio station music. I feel like I am lying on the Sofa all the while listening to Barry Manilow, the Carpenters. Serenading us the whole evening... Need to add some punch if he is want to do a persuasive speech. But still depends on what kind of audience you are addressing. I am not sure if he is delivering to some stubborn people like me, can I be convinced? Maybe stubborn people need to shout into their head to get the message across.

The last girl [ sorry! forgot her name :) ] has a very good sense of humour! I need learn from you on how to smile while giving speeches. You are the kind of person can cheer people up, bring laughter to the world. The one thing are find out about you, your weakness is she put too many stories into the speech. It's great to have stories, but I think is too much for a 5-7 min speech. Perhaps you should just make all the stories more in-depth. More 'Deep'.

My Grandma is ok now.

Miracle! It's a miracle! My grandma came out from coma, and she's as good as before! Doctor said that she had a very good fighthing spirit! I believe this run in the family.

Unfortunately my auntie, my mom's sis past away on Sunday because of internal bleeding while having her kidney dialysis.

Grandma

Visited Grandma yesterday in Assunta Hospital. No good. Breathing very hard. Unconscious and in coma.

After I called her, she begin to breath easier, but she's still waiting to see someone or something before she 'goes'. :(

Who is she waiting?

Project Speech #4

Just did my speech #4. Got a few feedbacks. My strength is my voice is very commanding and witty. My weakness is I lack 'the punch', no convincing supporting point; and no enthusiam in my speech. Need to work on that more.
A few more points I got is like, always give some positive points, have to raise my voice at the
end of my sentences.

Thank you for all the Toastmasters Mentors who has giving me all these valuable feedback!

Cannot reduce salary!

I ask H. last nite why he doesn't want to come back to work yet. He told me the boss deduct his salary. The boss told him he cannot pay the same amount because no payment from customers yet.

H will not come back as long as he get the same rate... and the boss is not going to give him the rate... And the project is being delay over and over and over...