Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt_drop

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\wb_rt_drop_timeseries.sql

Rem
Rem $Header: wb_rt_drop_timeseries.sql 02-jun-2005.08:21:51 sroychow Exp $
Rem
Rem wb_rt_drop_timeseries.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      wb_rt_drop_timeseries.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    sroychow    06/02/05 - sroychow_bug_fix7
Rem    sroychow    05/24/05 - Created
Rem

-----------------------------------------------------------
---
---   DROP TYPES AND TABLE TYPES
---
-----------------------------------------------------------

DROP FUNCTION DAY_GENERATOR_TFN;
DROP TYPE DAY_TYPE_TABLE ;
DROP TYPE DAY_TYPE ;

-------------------------------------------------
---
---   FISCAL CALENDAR: WEEK, MONTH, QUARTER, YEAR 
---
-------------------------------------------------

DROP FUNCTION FISCAL_WEEK_GENERATOR_TFN;
DROP TYPE FISCAL_WEEK_TYPE_TABLE ;
DROP TYPE FISCAL_WEEK_TYPE ;

DROP FUNCTION FISCAL_MONTH_GENERATOR_TFN;
DROP TYPE FISCAL_MONTH_TYPE_TABLE ;
DROP TYPE FISCAL_MONTH_TYPE ;

DROP FUNCTION FISCAL_QUARTER_GENERATOR_TFN;
DROP TYPE FISCAL_QUARTER_TYPE_TABLE ;
DROP TYPE FISCAL_QUARTER_TYPE ;

DROP FUNCTION FISCAL_YEAR_GENERATOR_TFN;
DROP TYPE FISCAL_YEAR_TYPE_TABLE ;
DROP TYPE FISCAL_YEAR_TYPE ;

-------------------------------------------------
---
---   CALENDAR: WEEK, MONTH, QUARTER, YEAR 
---
-------------------------------------------------

DROP FUNCTION CAL_WEEK_GENERATOR_TFN;
DROP TYPE CAL_WEEK_TYPE_TABLE ;
DROP TYPE CAL_WEEK_TYPE ;

DROP FUNCTION CAL_MONTH_GENERATOR_TFN;
DROP TYPE CAL_MONTH_TYPE_TABLE ;
DROP TYPE CAL_MONTH_TYPE ;

DROP FUNCTION CAL_QUARTER_GENERATOR_TFN;
DROP TYPE CAL_QUARTER_TYPE_TABLE ;
DROP TYPE CAL_QUARTER_TYPE ;

DROP FUNCTION CAL_YEAR_GENERATOR_TFN;
DROP TYPE CAL_YEAR_TYPE_TABLE ;
DROP TYPE CAL_YEAR_TYPE ;

-------------------------------------------------
---
---   OWB TIME SERIES 
---
-------------------------------------------------

DROP PACKAGE OWB_TIMESERIES;

-- ========================================================
-- END OF DROPS
-- ========================================================

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de