1.sql:
SELECTMIN(x.a_day)
FROM(SELECT to_date('01-10-2012','dd-mm-yyyy')+ROWNUM-1 a_day,SYSDATE
FROM(SELECTROWNUMFROM dual CONNECTBYROWNUM<=10)) x
WHERENOTEXISTS(SELECT1FROM holidays WHERE day_off = trunc(x.a_day))
AND(SELECT to_char(x.a_day,'DY')FROM dual)NOTIN('SAT','SUN');
2.holidays table data model:
create table HOLIDAYS
(
CURRENCY VARCHAR2(3) not null,
DAY_OFF DATE not null,
EX_CODE VARCHAR2(10) not null
)
3.holidays table data as follows:
(
CURRENCY VARCHAR2(3) not null,
DAY_OFF DATE not null,
EX_CODE VARCHAR2(10) not null
)
CURRENCY DAY_OFF EX_CODE
TWD 1/01/1990 TAIFO
TWD 2/01/1990 HKFE
TWD 1/01/2002 TAIFO
TWD 7/02/2002 TAIFO
TWD 8/02/2002 TAIFO
TWD 11/02/2002 TAIFO
TWD 12/02/2002 TAIFO
TWD 13/02/2002 TAIFO
TWD 14/02/2002 TAIFO
TWD 15/02/2002 TAIFO
TWD 28/02/2002 TAIFO
TWD 5/04/2002 TAIFO
TWD 1/05/2002 TAIFO
TWD 15/06/2002 TAIFO
TWD 21/09/2002 TAIFO
TWD 10/10/2002 TAIFO
GBP 1/01/2003 LME
TWD 1/01/2003 TAIFO
USD 1/01/2003 LME
USD 20/01/2003 LME
TWD 29/01/2003 TAIFO
TWD 30/01/2003 TAIFO
TWD 31/01/2003 TAIFO
TWD 1/02/2003 TAIFO
TWD 2/02/2003 TAIFO
TWD 3/02/2003 TAIFO
TWD 4/02/2003 TAIFO
TWD 5/02/2003 TAIFO
USD 17/02/2003 LME
TWD 28/02/2003 TAIFO
TWD 5/04/2003 TAIFO
GBP 18/04/2003 LME
GBP 21/04/2003 LME
TWD 1/05/2003 TAIFO
GBP 5/05/2003 LME
GBP 26/05/2003 LME
USD 26/05/2003 LME
TWD 4/06/2003 TAIFO
USD 4/07/2003 LME
GBP 25/08/2003 LME
USD 1/09/2003 LME
TWD 11/09/2003 TAIFO
TWD 10/10/2003 TAIFO
USD 13/10/2003 LME
USD 11/11/2003 LME
USD 27/11/2003 LME
GBP 25/12/2003 LME
USD 25/12/2003 LME
GBP 26/12/2003 LME
GBP 1/01/2004 LME
TWD 1/01/2004 TAIFO
USD 1/01/2004 LME
TWD 19/01/2004 TAIFO
USD 19/01/2004 LME
TWD 20/01/2004 TAIFO
TWD 21/01/2004 TAIFO
TWD 22/01/2004 TAIFO
TWD 23/01/2004 TAIFO
TWD 24/01/2004 TAIFO
TWD 25/01/2004 TAIFO
TWD 26/01/2004 TAIFO
USD 16/02/2004 LME
TWD 28/02/2004 TAIFO
TWD 4/04/2004 TAIFO
GBP 9/04/2004 LME
GBP 12/04/2004 LME
TWD 1/05/2004 TAIFO
GBP 3/05/2004 LME
GBP 31/05/2004 LME
USD 31/05/2004 LME
TWD 22/06/2004 TAIFO
USD 5/07/2004 LME
GBP 30/08/2004 LME
USD 6/09/2004 LME
TWD 28/09/2004 TAIFO
TWD 10/10/2004 TAIFO
USD 11/10/2004 LME
USD 11/11/2004 LME
USD 25/11/2004 LME
GBP 27/12/2004 LME
GBP 28/12/2004 LME
TWD 1/01/2005 TAIFO
GBP 3/01/2005 LME
USD 17/01/2005 LME
TWD 4/02/2005 TAIFO
TWD 5/02/2005 TAIFO
TWD 7/02/2005 TAIFO
TWD 8/02/2005 TAIFO
TWD 9/02/2005 TAIFO
TWD 10/02/2005 TAIFO
TWD 11/02/2005 TAIFO
USD 21/02/2005 LME
TWD 28/02/2005 TAIFO
GBP 25/03/2005 LME
GBP 28/03/2005 LME
TWD 5/04/2005 TAIFO
TWD 1/05/2005 TAIFO
GBP 2/05/2005 LME
TWD 2/05/2005 TAIFO
GBP 30/05/2005 LME
USD 30/05/2005 LME
TWD 11/06/2005 TAIFO
USD 4/07/2005 LME
GBP 29/08/2005 LME
USD 5/09/2005 LME
TWD 18/09/2005 TAIFO
TWD 10/10/2005 TAIFO
USD 10/10/2005 LME
USD 11/11/2005 LME
USD 24/11/2005 LME
JPY 23/12/2005 TSE
GBP 26/12/2005 LME
USD 26/12/2005 LME
GBP 27/12/2005 LME
JPY 1/01/2006 TSE
GBP 2/01/2006 LME
JPY 2/01/2006 TSE
USD 2/01/2006 LME
JPY 3/01/2006 TSE
JPY 9/01/2006 TSE
USD 16/01/2006 LME
TWD 26/01/2006 TAIFO
TWD 27/01/2006 TAIFO
TWD 30/01/2006 TAIFO
TWD 31/01/2006 TAIFO
TWD 1/02/2006 TAIFO
TWD 2/02/2006 TAIFO
USD 20/02/2006 LME
TWD 28/02/2006 TAIFO
JPY 21/03/2006 TSE
TWD 5/04/2006 TAIFO
GBP 14/04/2006 LME
GBP 17/04/2006 LME
GBP 1/05/2006 LME
TWD 1/05/2006 TAIFO
JPY 3/05/2006 TSE
JPY 4/05/2006 TSE
JPY 5/05/2006 TSE
GBP 29/05/2006 LME
USD 29/05/2006 LME
TWD 31/05/2006 TAIFO
USD 4/07/2006 LME
JPY 17/07/2006 TSE
GBP 28/08/2006 LME
USD 4/09/2006 LME
JPY 18/09/2006 TSE
TWD 6/10/2006 TAIFO
JPY 9/10/2006 TSE
TWD 9/10/2006 TAIFO
USD 9/10/2006 LME
TWD 10/10/2006 TAIFO
JPY 3/11/2006 TSE
JPY 23/11/2006 TSE
USD 23/11/2006 LME
GBP 25/12/2006 LME
USD 25/12/2006 LME
GBP 26/12/2006 LME
GBP 1/01/2007 LME
JPY 1/01/2007 TSE
TWD 1/01/2007 TAIFO
USD 1/01/2007 LME
JPY 8/01/2007 TSE
USD 15/01/2007 LME
JPY 12/02/2007 TSE
TWD 15/02/2007 TAIFO
TWD 16/02/2007 TAIFO
TWD 19/02/2007 TAIFO
USD 19/02/2007 LME
TWD 20/02/2007 TAIFO
TWD 21/02/2007 TAIFO
TWD 22/02/2007 TAIFO
TWD 23/02/2007 TAIFO
TWD 24/02/2007 TAIFO
TWD 25/02/2007 TAIFO
TWD 28/02/2007 TAIFO
JPY 21/03/2007 TSE
TWD 5/04/2007 TAIFO
GBP 6/04/2007 LME
TWD 6/04/2007 TAIFO
GBP 9/04/2007 LME
JPY 30/04/2007 TSE
TWD 1/05/2007 TAIFO
JPY 3/05/2007 TSE
JPY 4/05/2007 TSE
GBP 7/05/2007 LME
GBP 28/05/2007 LME
USD 28/05/2007 LME
TWD 18/06/2007 TAIFO
TWD 19/06/2007 TAIFO
USD 4/07/2007 LME
JPY 16/07/2007 TSE
GBP 27/08/2007 LME
USD 3/09/2007 LME
JPY 17/09/2007 TSE
JPY 24/09/2007 TSE
TWD 24/09/2007 TAIFO
TWD 25/09/2007 TAIFO
TWD 26/09/2007 HKFE
TWD 1/10/2007 HKFE
JPY 8/10/2007 TSE
USD 8/10/2007 LME
TWD 10/10/2007 TAIFO
TWD 19/10/2007 HKFE
USD 12/11/2007 LME
USD 22/11/2007 LME
JPY 23/11/2007 TSE
JPY 24/12/2007 TSE
GBP 25/12/2007 LME
TWD 25/12/2007 HKFE
USD 25/12/2007 LME
GBP 26/12/2007 LME
TWD 26/12/2007 HKFE
GBP 1/01/2008 LME
JPY 1/01/2008 TSE
TWD 1/01/2008 HKFE
TWD 1/01/2008 TAIFO
USD 1/01/2008 LME
JPY 14/01/2008 TSE
USD 21/01/2008 LME
TWD 4/02/2008 TAIFO
TWD 5/02/2008 TAIFO
TWD 6/02/2008 TAIFO
TWD 7/02/2008 HKFE
TWD 7/02/2008 TAIFO
TWD 8/02/2008 HKFE
TWD 8/02/2008 TAIFO
TWD 9/02/2008 HKFE
TWD 9/02/2008 TAIFO
JPY 11/02/2008 TSE
TWD 11/02/2008 TAIFO
USD 18/02/2008 LME
TWD 28/02/2008 TAIFO
JPY 20/03/2008 TSE
GBP 21/03/2008 LME
TWD 21/03/2008 HKFE
TWD 22/03/2008 HKFE
GBP 24/03/2008 LME
TWD 24/03/2008 HKFE
TWD 4/04/2008 HKFE
TWD 4/04/2008 TAIFO
JPY 29/04/2008 TSE
TWD 1/05/2008 HKFE
TWD 1/05/2008 TAIFO
GBP 5/05/2008 LME
JPY 5/05/2008 TSE
JPY 6/05/2008 TSE
TWD 12/05/2008 HKFE
GBP 26/05/2008 LME
USD 26/05/2008 LME
TWD 8/06/2008 TAIFO
TWD 9/06/2008 HKFE
TWD 1/07/2008 HKFE
USD 4/07/2008 LME
JPY 21/07/2008 TSE
GBP 25/08/2008 LME
USD 1/09/2008 LME
TWD 14/09/2008 TAIFO
JPY 15/09/2008 TSE
TWD 15/09/2008 HKFE
JPY 23/09/2008 TSE
TWD 1/10/2008 HKFE
TWD 7/10/2008 HKFE
TWD 10/10/2008 TAIFO
JPY 13/10/2008 TSE
USD 13/10/2008 LME
JPY 3/11/2008 TSE
USD 11/11/2008 LME
JPY 24/11/2008 TSE
USD 27/11/2008 LME
JPY 23/12/2008 TSE
GBP 25/12/2008 LME
TWD 25/12/2008 HKFE
USD 25/12/2008 LME
GBP 26/12/2008 LME
TWD 26/12/2008 HKFE
GBP 1/01/2009 LME
JPY 1/01/2009 TSE
TWD 1/01/2009 HKFE
TWD 1/01/2009 TAIFO
USD 1/01/2009 LME
TWD 2/01/2009 TAIFO
JPY 12/01/2009 TSE
USD 19/01/2009 LME
TWD 22/01/2009 TAIFO
TWD 23/01/2009 TAIFO
TWD 25/01/2009 TAIFO
TWD 26/01/2009 HKFE
TWD 26/01/2009 TAIFO
TWD 27/01/2009 HKFE
TWD 27/01/2009 TAIFO
TWD 28/01/2009 HKFE
TWD 28/01/2009 TAIFO
TWD 29/01/2009 TAIFO
TWD 30/01/2009 TAIFO
JPY 11/02/2009 TSE
USD 16/02/2009 LME
TWD 28/02/2009 TAIFO
JPY 20/03/2009 TSE
TWD 4/04/2009 HKFE
TWD 4/04/2009 TAIFO
GBP 10/04/2009 LME
TWD 10/04/2009 HKFE
TWD 11/04/2009 HKFE
GBP 13/04/2009 LME
TWD 13/04/2009 HKFE
JPY 29/04/2009 TSE
TWD 1/05/2009 HKFE
TWD 1/05/2009 TAIFO
TWD 2/05/2009 HKFE
GBP 4/05/2009 LME
JPY 4/05/2009 TSE
JPY 5/05/2009 TSE
GBP 25/05/2009 LME
USD 25/05/2009 LME
TWD 28/05/2009 HKFE
TWD 28/05/2009 TAIFO
TWD 29/05/2009 TAIFO
TWD 1/07/2009 HKFE
JPY 20/07/2009 TSE
GBP 31/08/2009 LME
USD 7/09/2009 LME
JPY 21/09/2009 TSE
JPY 22/09/2009 TSE
JPY 23/09/2009 TSE
TWD 1/10/2009 HKFE
TWD 3/10/2009 HKFE
TWD 3/10/2009 TAIFO
TWD 10/10/2009 TAIFO
JPY 12/10/2009 TSE
USD 12/10/2009 LME
TWD 26/10/2009 HKFE
JPY 3/11/2009 TSE
USD 11/11/2009 LME
JPY 23/11/2009 TSE
USD 26/11/2009 LME
JPY 23/12/2009 TSE
GBP 25/12/2009 LME
TWD 25/12/2009 HKFE
USD 25/12/2009 LME
TWD 26/12/2009 HKFE
GBP 28/12/2009 LME
JPY 1/01/2010 TSE
TWD 1/01/2010 HKFE
TWD 1/01/2010 TAIFO
JPY 11/01/2010 TSE
JPY 11/02/2010 TSE
TWD 11/02/2010 TAIFO
TWD 12/02/2010 TAIFO
TWD 13/02/2010 HKFE
TWD 13/02/2010 TAIFO
TWD 14/02/2010 TAIFO
TWD 15/02/2010 HKFE
TWD 15/02/2010 TAIFO
TWD 16/02/2010 HKFE
TWD 16/02/2010 TAIFO
TWD 17/02/2010 TAIFO
TWD 18/02/2010 TAIFO
TWD 19/02/2010 TAIFO
TWD 28/02/2010 TAIFO
JPY 22/03/2010 TSE
TWD 2/04/2010 HKFE
TWD 3/04/2010 HKFE
TWD 5/04/2010 HKFE
TWD 5/04/2010 TAIFO
TWD 6/04/2010 HKFE
JPY 29/04/2010 TSE
TWD 1/05/2010 HKFE
TWD 1/05/2010 TAIFO
JPY 3/05/2010 TSE
JPY 4/05/2010 TSE
JPY 5/05/2010 TSE
TWD 21/05/2010 HKFE
TWD 16/06/2010 HKFE
TWD 16/06/2010 TAIFO
TWD 1/07/2010 HKFE
JPY 19/07/2010 TSE
JPY 20/09/2010 TSE
TWD 22/09/2010 TAIFO
JPY 23/09/2010 TSE
TWD 23/09/2010 HKFE
TWD 1/10/2010 HKFE
TWD 10/10/2010 TAIFO
JPY 11/10/2010 TSE
TWD 16/10/2010 HKFE
JPY 3/11/2010 TSE
JPY 23/11/2010 TSE
JPY 23/12/2010 TSE
TWD 25/12/2010 HKFE
TWD 27/12/2010 HKFE
JPY 10/01/2011 TSE
TWD 3/02/2011 HKFE
TWD 4/02/2011 HKFE
TWD 5/02/2011 HKFE
JPY 11/02/2011 TSE
JPY 21/03/2011 TSE
TWD 5/04/2011 HKFE
TWD 22/04/2011 HKFE
TWD 23/04/2011 HKFE
TWD 25/04/2011 HKFE
JPY 29/04/2011 TSE
TWD 2/05/2011 HKFE
JPY 3/05/2011 TSE
JPY 4/05/2011 TSE
JPY 5/05/2011 TSE
TWD 10/05/2011 HKFE
TWD 6/06/2011 HKFE
TWD 1/07/2011 HKFE
JPY 18/07/2011 TSE
TWD 13/09/2011 HKFE
JPY 19/09/2011 TSE
JPY 23/09/2011 TSE
TWD 1/10/2011 HKFE
TWD 5/10/2011 HKFE
JPY 10/10/2011 TSE
JPY 3/11/2011 TSE
JPY 23/11/2011 TSE
JPY 23/12/2011 TSE
TWD 26/12/2011 HKFE
TWD 27/12/2011 HKFE
JPY 2/01/2012 TSE
TWD 2/01/2012 HKFE
JPY 9/01/2012 TSE
TWD 23/01/2012 HKFE
TWD 24/01/2012 HKFE
TWD 25/01/2012 HKFE
JPY 20/03/2012 TSE
TWD 4/04/2012 HKFE
TWD 6/04/2012 HKFE
TWD 7/04/2012 HKFE
TWD 9/04/2012 HKFE
TWD 28/04/2012 HKFE
JPY 30/04/2012 TSE
TWD 1/05/2012 HKFE
JPY 3/05/2012 TSE
JPY 4/05/2012 TSE
TWD 23/06/2012 HKFE
TWD 2/07/2012 HKFE
JPY 16/07/2012 TSE
JPY 17/09/2012 TSE
TWD 1/10/2012 HKFE
TWD 2/10/2012 HKFE
TWD 3/10/2012 TAIFO
TWD 4/10/2012 TAIFO
TWD 5/10/2012 TAIFO
JPY 8/10/2012 TSE
TWD 23/10/2012 HKFE
JPY 23/11/2012 TSE
JPY 24/12/2012 TSE
TWD 25/12/2012 HKFE
TWD 26/12/2012 HKFE