Sol 3

I see that Oracle has released a set of tools for .NET 3.5 and Visual Studio 2008. If you are an Oracle based .NET developer, this should be good stuff.  I just wish I could find a new customer that wants to do Oracle and .NET 3.5.  As much as I love working in Sql Server, I do long to get back to doing Oracle based development.

http://www.oracle.com/technology/tech/windows/index.html Yes, its here now.

When you use one database platform long enough you start to think everything you do is ANSI SQL-92 compliant.  Until you switch database platforms that is!  Then you find the simple things no longer work.  Take for example the TOP clause used so often in MS SQL Server.  It does not work on Oracle.  <sigh/> I've been ...

When you use one database platform long enough you start to think everything you do is ANSI SQL-92 compliant. Until you switch database platforms that is! Then you find the simple things no longer work. Take for example the TOP clause used so often in...(read more)

When you use one database platform long enough you start to think everything you do is ANSI SQL-92 compliant.  Until you switch database platforms that is!  Then you find the simple things no longer work.  Take for example the TOP clause used so often in MS SQL Server.  It does not work on Oracle.  <sigh/> I've been ...

 This is a slick little trick to get around the need for a complete TNSNAMES.ORA file:Have you ever tried to access an oracle instance in VBScript? This is not to complicated, but normally you need an additional file called tnsnames.ora in the oracle installation directory. This article describes an easy way to access an oracle instance ...

This is a slick little trick to get around the need for a complete TNSNAMES.ORA file: Have you ever tried to access an oracle instance in VBScript? This is not to complicated, but normally you need an additional file called tnsnames.ora in the oracle...(read more)

 This is a slick little trick to get around the need for a complete TNSNAMES.ORA file:Have you ever tried to access an oracle instance in VBScript? This is not to complicated, but normally you need an additional file called tnsnames.ora in the oracle installation directory. This article describes an easy way to access an oracle instance ...

Found it.  Buried in a forum posting somewhere...    @echo offFOR %%f IN (.\sql\tab1\*.sql) DO exit | sqlplus [uid]/[pwd]@[db] @''%%f''FOR %%f IN (.\sql\tab2\*.sql) DO exit | sqlplus [uid]/[pwd]@[db] @''%%f'' Add ''exit | '' to the beginning of the command line for sqlplus. Add quotes around the %%f ...

Found it. Buried in a forum posting somewhere... @echo off FOR %%f IN (.\sql\tab1\*.sql) DO exit | sqlplus [uid]/[pwd]@[db] @ '' %%f '' FOR %%f IN (.\sql\tab2\*.sql) DO exit | sqlplus [uid]/[pwd]@[db] @ '' %%f '' Add '' exit | '' to the beginning of the command...(read more)