July 2009
Oracle timesten 11g new feature
Timesten 11g , a version that has too much expectation has been released.
Timesten is fast and good , even much faster than the Oracle database. But the fact that previous edition of timesten 's api is different from Oracle database has prevented some customer from choosing this great product. Why? Of course we don't want to re-write our applications all over again in order to connect to timesten.
The most compelling new featureRead more
How to get efficient support from Oracle -metalink and OTN Forum
When you have some problem with your Oracle product installation or other problems and you can not figure it out for a few days, What 're you going to do?
Some of us might just use google to search the solution. It works sometimes but not every time! espetially when you're using a new version which is used by only few people.
So what 's the best way to solve your Oracle product related problem ?
The best answer - metalink
What is metalink?Read more
What 's Oracle Real Application Cluster - RAC for high availability and scalability
Oracle Real Application Cluster or RAC has become more popular than ever . It is a very useful option of Oracle database enterprise edition. A lot of customer today choose this option without asking why ther will need it . Only because they know that RAC target at high end requirement. But why ?
It is not so difficult to answer this question actually that RAC is designed for solving two simple problem:
- High availabity
- Scalability
High Availability for RACRead more
Oracle SQL Developer 1.5 - enable debug information
when I use SQL Developer, there 're several times when a screen just disappear without any pop-up error window and I don't know why. SQL Developer do not output any debug information by default.
There is difference between different version for setting up debug mode for SQL Developer. The debug mode for version 1.5 is much more easy to setup.
Steps to for debug mode setupRead more
Oracle Application Express - Apex overview
Recently I use Oracle application express to develop a partner management applications, The more I use it , the more I feel that it is really great tools that we all should learn to use it to develop small applications to improve productivity of our daily work.
It is easy to learn and most of the functionality is wizard guided. It surely serve as a great 'Excel replacer' or 'Excel enhancer' , most important of all , it is free!Read more
Oracle Application Express - add mutliple chart on the same page
To add multiple chart and tabular table to the same apex page is an common requirement for apex applications development. and it is easy to implment this feature using apex 's concept of 'Region'.
For Apex, Each chart or table is placed inside a 'region', so multiple 'region' could be arranged on different section of the same page to make up the multiple chart on the same page effect.
The above Apex page is made of two region which data could be draw from totally different data tablesRead more
Use Oracle Application Express to import excel data into oracle database
Recently I need to import some excel data into database for data analysis. At the fist I use SQL Developer to do the impot, but I encouter many problems. So I decide to use apex to do the import and it turn out to be really much better than the SQL Developer import function.
The apex Excel import function is easy and wizard guided, and here 's the step:Read more
SQL Developer 1.5 excel import - Date Format problem
When I use SQL Developer to import Excel with date format column into Oracle database. Error from the date column stop the import.
In the preview window, The date column indicate there is date format problem (Date in native language).
SQL Developer import data from Excel to Oracle problem - remove the invisible space from Excel
Today I have to import last year 's sales data into database for sales analytics. the sales data is in excel format. I have to work out a way to import the excel data into Oracle database.
Fortunetly Oracle 's free tools SQL Developer provide an easy way for importing excel data. So I download and setup the Oracle SQL Developer in my laptop.
SQL Developer is very easy to use. I thought I could easily import the data into Oracle database, just right-click at the table and select the menu 'import data', It is wizard guided process that is easy to follow.Read more
Different Partner type and partner value in software business
There 're different types of partners in the market, Usually we label the company with the products as the 'brand owner'. and the vendors which help the 'brand owner' sell their product as the partners.
In software industry, We usually devide the partners into two major category:
- VAD: value added distributor
- SI/ISV: system integrator/indepentdant software vendor, or partners who use our product to build solution or applications
VAD partnerRead more