Posted in DBA, tagged DBA, SOX, TIPS on May 3, 2008 | Leave a Comment »
Be proactive. Don’t let your manager be blindsided in the hallway by some problem you’ve been working on. “You’d be surprised at people who are up all night fixing a problem and don’t tell anyone,” Floss said.
Be flexible. Are you willing to pitch in on anything? “My favorite person is the person who will do [...]
Posted in DB2, Oracle, tagged db2 luw, DB2 Null, Oracle, SQL Server, unique index on May 3, 2008 | Leave a Comment »
By decipherinfosysThis project needed to support having multiple NULL values in the column and still have a UNIQUE constraint. That is allowed by Oracle but not in SQL Server and DB2 LUW. There is a way to make this work in SQL Server and DB2 LUW also but that requires a work-around. Consider this table:
CREATE [...]
Posted in DB2, Oracle, tagged DB2, Oracle, sql query, sql query minus on May 3, 2008 | Leave a Comment »
User comments for the following queries are highly appreciated..
How does one compare data between 2 identical tables in DB2 ? In Oracle, one can use the minus option which is not there in DB2.
