Browse > Home / Archive: January 2008

My Plans for 2008

January 19, 2008

Even though half of January 2008 had passed, it’s not to late to have a new year’s resolution. I’m jotting down the following according to what comes to my mind first.

  1. Learn Java
  2. Continue to prepare for my OCA certification.
  3. Keep my family happy and provide what they need.
  4. Continue to learn new things and improve my professional and technical skills.
  5.  Always keep my attention to details.
  6. Visit Disneyland if possible.
  7. Think over and over if I can take my Masteral in Enterprise Architecture.

I’ll continue to update this list if anything comes to my mind.

Filed Under Plans · Leave a Comment  

I’m One of the Very First Oracle Certified Expert - Oracle Database SQL Expert

January 19, 2008

Looking back to 2006, after my long vacation from work, I planned myself to focus on certification. I want to certify my skills and make me more marketable globally. I don’t have anything to look for in my company - Accenture. I want that when I get back to work I can bring a significant qualify of work to my project.

I started to prepare for my very first certification exam which is 1Z0-007 - Introduction to SQL. I’m very happy to passed this exam with 90.4% score. I’m planning to take my next step to earn Oracle Certified Associate by taking PL/SQL exam but a new Oracle certification got my attention. It’s about the Oracle Certified Expert.

As a software designer and developer, Oracle Certified Expert’s Oracle Database SQL Expert looks appealing to me. I only need to take one exam and I’ll earn an Oracle Certification. Other Oracle guys like Lauren Schneider, Jaffar and Jochen Van de Voorde participated in the beta exam.

I have started my preparation around August since the original end date of the beta exam is September 15, 2006. I took a week of vacation for the whole week of September 12, 2006. Unfortunately, last Friday, my project is on Assembly Test period and logged a couple of defects. I need to work on weekends which makes my time to review shorter. I fixed some defects during till Sunday evening.

Monday morning, I have 2 days left to prepare. I crammed to prepare and took my exam last September 12, 2006. A day before the last day of beta exam, Oracle extended the beta exam till October 15, 2007. With the new date I’m hoping that I will get the results on December 24, 2007 which is the end of the 10-week period after the last day of beta exam. But there is no results that were release, till January 14, 2008 when I check my account in the Prometric website.

Oracle Certified Expert Result

Oracle Certified ExpertThere is no scores yet. I’m still waiting for the official notification. Not sure if it’s from Oracle or from Prometric. Now I’m one of the very first Oracle Certified Expert - Oracle Database SQL Expert. Did you passed the Oracle Database SQL Expert exam? Come and post your scores here.

Filed Under Oracle · 1 Comment  

How to display newline in Excel?

January 12, 2008

The commonly used to display newline in Visual Basic is using VbCrLF. But the problem is you will see a small rectangle at the end of the line.

Excel New Line

PLAIN TEXT
Visual Basic:
  1. Dim strFirstLine As String
  2. Dim strSecondLine As String
  3.  
  4. strFirstLine = "This is the first line"
  5. strSecondLine = "This is second line"
  6.  
  7. Worksheets("Sheet1").Range("b4").Value = _
  8. strFirstLine & vbCrLf & strSecondLine

To solve this problem, you will need to change the code from VbCrLF to VbLf.

PLAIN TEXT
Visual Basic:
  1. Dim strFirstLine As String
  2. Dim strSecondLine As String
  3.  
  4. strFirstLine = "This is the first line"
  5. strSecondLine = "This is second line"
  6.  
  7. Worksheets("Sheet1").Range("b4").Value = _
  8. strFirstLine & vbLf & strSecondLine

Excel New Line

Filed Under VBA · Leave a Comment