Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "Oracle"

6

If you think uninstalling SQL Server is a pain, have fun with Oracle

Because of a job change next week I have no need for Oracle anymore, I decided to remove it. I know that some people complain that uninstalling SQL Server is a pain, well those people should just be quiet from now on, uninstalling Oracle is much worse.…

Read More...
0

Yeah, I am sure that is the reason we have Oracle on Azure and Hyper-V now

Microsoft Corp. and Oracle Corp. today announced a partnership that will enable customers to run Oracle software on Windows Server Hyper-V and in Windows Azure. Customers will be able to deploy Oracle software — including Java, Oracle Database and Oracl…

Read More...
1

Unique index difference between Oracle and SQL Server

When working with different database systems you have to be aware that some things work differently from one system to another. I already blogged a couple of times about differences between SQl Server and Oracle, those post are the following
Truncate r…

Read More...
0

An Oracle NULL/Blank gotcha when coming from SQL Server

In my Differences between Oracle and SQL Server when working with NULL and blank values post I already showed you how blanks and NULLS are handled differently between Oracle and SQL Server. Today I found another interesting tidbit.

I you have a varc…

Read More...
0

The OLE DB Source and the Oracle Date Literal

Recently I had some issues using ANSI date literals in an SSIS OLE DB source query to an Oracle database.

Read More...
0

Truncate rollback differences between SQL Server and Oracle

I wrote a blogpost about the fact that there is a common myth that you can’t rollback a truncate statement in SQL this post was written on June 13, 2007 and it showed you that you could rollback a truncate. Here is some code that shows that.

CREATE…

Read More...
1

What is the Dual table in Oracle and why do I need it?

When coming from SQL Server, you might find it weird that you don’t see code that looks like this

select 2

That code won’t run in Oracle, unlike SQL Server, Oracle requires the use of the FROM clause in its syntax. This is why Oracle has DUAL

Read More...
1

Differences between Oracle and SQL Server when working with NULL and blank values

If you ever have to start working with Oracle you have to keep in mind that NULLs and blank values don’t work exactly the same as in SQL Server. Let’s take a look at some examples

Create this table and insert some rows
create table TestNull(Col2 var…

Read More...
7

T-SQL Tuesday #37: Join me in a month of Joins

 
This month’s T-SQL Tuesday is hosted by Sebastian Meine (blog | twitter) and the topic is joins. He has a whole month worth of topics about joins: A Join A Day – Introduction.

My blog post is about something weird I encountered while…

Read More...
1

Anecdotes about SQL AKA post 400

This is my 400th blog post here on lessthandot and I decide to steal borrow Chrissie’s idea and ask a bunch of people if they have an interesting story to share about SQL.

Here is how I asked it

As you may or may not know I’m an avid SQL fan.
I’m…

Read More...
Next Page »