Thursday, June 28, 2007

oracle: data with single quote

When using java, prepared statement can insert string with single quote easily. I tried to achieve the same thing with python. I finally got prepared statement using cx_Oracle, but it was very ugly and unintuitive.
I tried this task with postgresql hoping for a better solution. Things were worse in Postgres. I knew that my favorite psycopg2 does not support prepared statement, yet. But, the rest of the drivers, such as pypgsql and all others that I have researched, were in the same status.

Anyway, I found this this link:
http://catherinedevlin.blogspot.com/2005_07_01_archive.html

Oracle had a different idea. Different quote operator. q'| |'. Like python block quote('''), it relieves single quote when wrapped around it.

Insert into tbl(txt) values ( q'|Hello world's geeks.|' );

Coming back to work after the vacation

Thanks to my second son, Jaron, I had a wonderful vacation. It was the best and the busiest vacation that I had. Actually, I came back early this week. I already spent three business days in my office. I was afraid of the big eagerness of leaving my office, but that wasn't too much bad. I sit down nicely and processed pending jobs.
Programming skills needed time to get up to speed. English was troubled for a while, Korean much more fluent :) I hope my kids pick up Korean first.

Now, the good days of vacation is over and the life resumes with an additional responsibility. I don't mind, though. Maybe, Jake will object?

Thursday, June 7, 2007

my new family.

On May 26th, 2007, my second son, Jaron, was born. Having paternity leave now. Yeah~~~. It was the same hospital, the same level, but the room was the other side of hall as we were there two years ago. Funny thing is that not my wife but I am having emotional fluctuation mostly toward happy side with a little bit of tears ( Shame on ME, a man with tear! )
Anyway, his first image brought a deja-vu. He looks exactly the same with my first one, Jake. When getting a chance, I want to show pictures of my sons side by side. My wife and I took a picture on purpose when we put Jaron in the baby basket for the first time. We successfully took the same angle, the same pause, but in different clothes two years ago as we took Jake. If somebody sees these pictures side by side, 'Hmmmm,... Why did you change baby's clothes on discharge from the hospital? Were you guys bored enough?'