Monthly Archives: April 2007

Oracle Enterprise Linux for another group of users

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

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

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

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

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

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)

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