Monthly Archives: April 2007

Oracle Enterprise Linux for another group of users

Posted on April 29, 2007 by chanmingman

Oracle Enterprise Linux for another group of users   Microsoft Windows Server is a good Operating System. Despite how good it is, there will still be a group of users who might prefer to use or try another Operating System. … Continue reading →

Posted in Operating System | Leave a comment

How to use ref cursor in .Net for Oracle Database

Posted on April 28, 2007 by chanmingman

How to use ref cursor in .Net for Oracle Database   Many C# developers will not know how to do when they realized there is something called ref cursor in Oracle that which may not need to be explicitly handle … Continue reading →

Posted in .Net | Leave a comment

How to develop and deploy a .NET stored procedure

Posted on April 24, 2007 by chanmingman

How to develop and deploy a .NET stored procedure   Developers always see many articles in MSDN site on how to develop and deploy a .NET stored procedure for Microsoft SQL 2005. Can we do this in Oracle 10g using … Continue reading →

Posted in .Net | Leave a comment

Flashback feature in Oracle Database 10g R2

Posted on April 22, 2007 by chanmingman

Flashback feature in Oracle Database 10g R2   One of the top features for DBA is Flashback recovery. As mentioned in my previous blog, to see all the top features go to http://www.oracle.com/technology/pub/articles/10gdba/index_r2.html. The article at http://www.oracle.com/technology/pub/articles/10gdba/pdf/10gdba_complete.pdf dictates that the … Continue reading →

Posted in Servers | Leave a comment

Stored Procedures in Oracle and Microsoft SQL

Posted on April 19, 2007 by chanmingman

Stored Procedures in Oracle and Microsoft SQL   I used to do the below in Microsoft SQL server to create a stored procedure   CREATE PROCEDURE HumanResources.uspGetAllEmployees AS SELECT LastName, FirstName, JobTitle, Department FROM HumanResources.vEmployeeDepartment;   as in http://msdn2.microsoft.com/en-us/library/ms187926.aspx.   … Continue reading →

Posted in .Net | Leave a comment

LINQ

Posted on April 16, 2007 by chanmingman

LINQ   What is coming in the next version of C#? LINQ, compiler features, IDE features, visit this link and download the video to watch. What I like is the Lambda Expressions. Some one should try more on something Func<int,int> … Continue reading →

Posted in .Net | Leave a comment

Getting Started with Oracle Data Provider for .NET (C# Version)

Posted on April 13, 2007 by chanmingman

Getting Started with Oracle Data Provider for .NET (C# Version)   Go to http://www.oracle.com/technology/obe/odt/getstarted/getstarted_c.htm to have a good step by step to start.   One thing you might want to watch out is this part:   string oradb = "Data … Continue reading →

Posted in .Net | Leave a comment

Oracle Explorer in Visual Studio 2005

Posted on April 13, 2007 by chanmingman

Oracle Explorer in Visual Studio 2005   Take a look of WinAppOdp.jpg. You might see Oracle Explorer there and you might want to get one too. Download the Oracle Developer Tools for Visual Studio .NET at http://www.oracle.com/technology/tech/dotnet/tools/index.html.   Start Visual … Continue reading →

Posted in .Net | 2 Comments

C++ with Visual Studio Orcas

Posted on April 11, 2007 by chanmingman

C++ with Visual Studio Orcas   I have re-written the VB.NET linked list in C++ using Visual Studio Orcas (http://msdn2.microsoft.com/en-us/vstudio/aa700831.aspx) and it works perfectly fine.   The complete code shown as below:   #include "stdafx.h" #include <iostream> using namespace std; … Continue reading →

Posted in .Net | Leave a comment

Dataset with Oracle 10g Enterprise

Posted on April 7, 2007 by chanmingman

Dataset with Oracle 10g Enterprise   After install Oracle 10g you will find a folder like C:oracleproduct10.2.0db_1odp.net in your computer if your Oracle home folder is in C drive in a Windows machine and your installation option is basic. Under … Continue reading →

Posted in .Net | Leave a comment