Being Coldfusion programmer, parsing list value in coldfusion is very simple. If list value is "list1|list2|list3|list4", we can parse with ListToArray in Coldfusion as follow.

Above coding, we must need to assign true for includeEmptyFields if list value will contain empty. In Oracle, it's touch to parse and we need to write Oracle function.

[More]

This entry was posted on April 24, 2012 at 9:32 AM and has received 1293 views. There are currently 0 comments. Print this entry.

Today, I know how to wrap Oracle objects called stored procedure, functions, views and so on. It's because I want to make secure for our project source.

How-to-do is very simple.

1) Open common prompt 2) and go to Bin folder under Oracle just like "C:\Oracle\Bin" 3) Then type following script

[More]

This entry was posted on March 25, 2012 at 6:44 PM and has received 1103 views. There are currently 0 comments. Print this entry.

Today, I need to sync data of different schema in same SID (same database). Honestly, I'm not very good at Oracle but I gotta develop this kind of project. That's why I've asked in StackOverFlow and @Luck Woodwords and he replied good solution.

http://stackoverflow.com/questions/9452488/how-to-create-oracle-dblink-in-same-sid#comment11957843_9452488

[More]

This entry was posted on February 27, 2012 at 1:05 AM and has received 989 views. There are currently 0 comments. Print this entry.

Today, I've found how to backup/export Oracle database with bat file. I've just created it for only one schema first. Why I'm using to import Oracle with bat file because of there is no auto backup feature in Oracle (as far as I know). That's why it's needed to create bat file and integrate with window task scheduler (run daily).

First of all, open Notepad and save as OracleBackup.bat first. Then, paste following code into this file.

[More]

This entry was posted on January 12, 2012 at 5:57 AM and has received 2109 views. There are currently 2 comments. Print this entry.

This entry was posted on November 29, 2011 at 8:15 PM and has received 1560 views. There are currently 13 comments. Print this entry.

Being developer, we must need to know how to write SQL query, functions, views and stored procedures for our development as long as we are not using ORM. I'm not sure using ORM is kinda useful or not in our development life cycle but we shouldn't forget our writing query skill. That's why I need to practise 1Z0-047 for enhancing my Oracle query skill with 1Z0-047 exam simulator of ucertify,

[More]

This entry was posted on November 15, 2011 at 11:38 PM and has received 1307 views. There are currently 1 comments. Print this entry.

In this 2011, I feel like myself to take almost certification of what I know and what I'm using in my development space. Being programmer, I didn't say almost certificates are needed but just like non-computer science graduated like me, those certificate are very needed. Because almost people won't know why I'm surviving in IT without having computer science graduate. That's why I believe I'm not wrong to take certificate. 

When I was in Myanmar, we use Microsoft SQL as our database because which is simple and easy to use with their UI. When I started working in Singapore (2009), our company use Oracle as database system instead of Microsoft SQL. Since that time, I'm addictive at Oracle because of the way of writing stored procedure, functions and views. That's why I think I need to have at least one Oracle certificate to let people know that I know Oracle.

That's why I decided to take 1Z0-051 exam of Oracle. It's called SQL Fundamentals exam which is suitable for me to take as beginner state of Oracle developer. Below is the exam topic of 1Z0-051.

[More]

This entry was posted on October 19, 2011 at 6:51 AM and has received 2378 views. There are currently 0 comments. Print this entry.

Yesterday, I knew how to create new Listener and TNS in Oracle. It's kinda simple if you know how to do. If not, so complicated

Create new Listener in Oracle

First of all, we need to go Oracle first. Then, we need to go Configuration and migration tools > Net Manager.

[More]

This entry was posted on September 23, 2011 at 6:16 AM and has received 2021 views. There are currently 0 comments. Print this entry.

Here is my first web-based project for my company. Our target is for customer who want to register Patient thru online. This project is based for iPad but it can work either on Android based tablet. For this project, I've used jQueryMobile framework, Coldfusion 9 and Oracle 11g. For jQueryMobile part, I've created our own customize theme for this project and added some JS coding into jQueryMobile existing scripts. Just example: my boss want me to highlight which field has been filled up by users and need to categorize for mandatory field. As you know, it's difficult to change or add some JS coding into their existing core JS file because we need to know the flow of existing JS coding. Likewise, what we add or change JS coding will impact the whole existing JS coding. I took 2 days to study the whole existing JS coding but it's not enough time honestly for it.

Below is some of my change logs into jQueryMobile existing JS coding for this project.

[More]

This entry was posted on July 22, 2011 at 6:28 PM and has received 1685 views. There are currently 0 comments. Print this entry.

In these days, I needed to manipulate Query statement in Oracle. Because, for database part, we don't want our CF to calculate the amount of our system. That's why we just let Oracle to do as much as database part can do. Because we don't want JRun can be more loaded because of such calculation and minor cases and we are always try to assign less process for our CF. Today, I need to develop some calculation in our projects for the following cases.

[More]

This entry was posted on June 24, 2011 at 12:55 AM and has received 1604 views. There are currently 2 comments. Print this entry.