You must watch out for many subtle and not-so-subtle traps when translating Oracle queries to SQL Server. Just as T-SQL is the language engine of SQL Server, PLSQL is that of Oracle. Both these ...
I just started a new job a couple of weeks ago that requires me to pull a bunch of data out of an Oracle 8i server. For various reasons I can't use the Oracle tools (or the Oracle client), and the ...
SQL is a convenient way to manage and query your data, but badly written queries can tie up your database. Here are seven common SQL traps and how to avoid them. Database developers have it tough.