-
Microsoft deprecates its ADO.NET Oracle provider (System.Data.OracleProvider)
I found out today that Microsoft has decided to deprecate its provider for Oracle. In a related note, I got quoted in Jeffery Schwartz’s news article in Visual Studio Magazine about this new development. -Ben
-
Oracle for SQL Server Developers, Vol. 4: Identity Columns & Sequences
Picking up where I left off in my previous “Oracle for SQL Server Developers” posts (one, two, three)… In SQL Server, we commonly have a primary key column that is a integer and this number gets incremented, created, and inserted automatically by the database. This is a SQL Server identity column and it makes our…
-
Oracle For SQL Server Developers, Vol. 3
Here’s another post in the Oracle For SQL Server Developers series (vol1, vol2). The goal with this post is to help you get a feel for some common column data types in Oracle. Tip #16: Data Type Equivalents for Numbers SQL Server Oracle int NUMBER float, real NUMBER(precision, scale) In Oracle, a number can be…
-
Oracle For SQL Server Developers, Vol. 2
Here’s another post in my Oracle for SQL Server Developers series. Tip #7: What is SQL*Plus and how do I connect to Oracle with SQL*Plus? SQL*Plus is a command-line client for talking to Oracle. It’s similar to SQL Server’s sqlcmd.exe. It’s usually installed in $ORACLE_HOMEBINsqlplus.exe so on my machine with a default install that path…
-
Oracle For SQL Server Developers, Vol. 1
When I first started working with the Oracle database back in 2001, I remember how difficult it was to figure ANYTHING out. I had plenty of experience managing SQL Server, designing databases with SQL Server, and implementing applications with SQL Server but getting even the most basic tasks done in Oracle was a major feat.…