Some DBA tips

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 [...]

Read Full Post »

Multiple NULL values in a Unique index in SQL Server/DB2 LUW

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 [...]

Read Full Post »

Compare data between 2 identical tables in DB2

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.

Read Full Post »

Oracle Date display Code

Requirement: if a Month from drop down list gets selected, the corresponding days populates in the tabular form. For ex, if January 2008 gets selected, then it should populate 1st january-Tuesday,2nd January-Wednesday and so on.
Option 1:
SELECT TO_CHAR(SYSDATE, ‘fmDDTH’)||’ of ‘||TO_CHAR (SYSDATE, ‘fmMonth – day’)||’, ‘||TO_CHAR(SYSDATE, ‘YYYY’) “Ides” FROM DUAL
Option 2:
CREATE OR REPLACE PROCEDURE show_dates (i_date [...]

Read Full Post »

Significant of Oracle Password File in Login

Password file is required to start the database up. There is no mandate to configure manually; the database can take care of that and only changes it when a user is granted SYSDBA or database startup privileges. The password file is used when starting the instance and controls access to the control files (startup mount) [...]

Read Full Post »