Feeds:
Posts
Comments

Posts Tagged ‘Oracle’

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

Posted in DB2, Oracle, tagged , , , , 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 [...]

Read Full Post »

Compare data between 2 identical tables in DB2

Posted in DB2, Oracle, tagged , , , 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.

Read Full Post »

Killing the Oracle DBMS_JOB

Posted in Oracle DBA, tagged , on April 10, 2008 | Leave a Comment »

 
 while ago I published an article on Killing the Oracle DBMS_JOB. This was also a favorite of some of my readers and I still get questions on it today. So I thought I would post it here as it has surely been lost out in the web archives unless you search deep. Just remember the [...]

Read Full Post »

Oracle Date display Code

Posted in Functions, Oracle, tagged , , on April 8, 2008 | Leave a Comment »

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 »