Re: insert values in a table using procedures

<vgpotnuru7_at_gmail.com> a écrit dans le message de news: ba2ce17e-3532-4ec8-92d5-6f13a2185159_at_w39g2000prb.googlegroups.com...
|I have 3 tables i.e.
|
| SQL> desc sales;
| Name Null? Type
| ----------------------------------------- -------- ----------------
|
| PROD_ID NOT NULL NUMBER(6)
| CUST_ID NOT NULL NUMBER
| TIME_ID NOT NULL DATE
| CHANNEL_ID NOT NULL CHAR(1)
| PROMO_ID NOT NULL NUMBER(6)
| QUANTITY_SOLD NOT NULL NUMBER(3)
| AMOUNT_SOLD NOT NULL NUMBER(10,2)
|
| SQL> desc promotions
| Name Null? Type
| ----------------------------------------- -------- ----------------
|
| PROMO_ID NOT NULL NUMBER(6)
| PROMO_NAME NOT NULL VARCHAR2(20)
| PROMO_SUBCATEGORY NOT NULL VARCHAR2(30)
| PROMO_CATEGORY NOT NULL VARCHAR2(30)
| PROMO_COST NOT NULL NUMBER(10,2)
| PROMO_BEGIN_DATE NOT NULL DATE
| PROMO_END_DATE NOT NULL DATE
| PROMO_TOTAL VARCHAR2(15)
|
| SQL> desc times
| Name Null? Type
| ----------------------------------------- -------- ----------------
|
| TIME_ID NOT NULL DATE
| DAY_NAME NOT NULL VARCHAR2(9)
| DAY_NUMBER_IN_WEEK NOT NULL NUMBER(1)
| DAY_NUMBER_IN_MONTH NOT NULL NUMBER(2)
| CALENDAR_WEEK_NUMBER NOT NULL NUMBER(2)
| FISCAL_WEEK_NUMBER NOT NULL NUMBER(2)
| WEEK_ENDING_DAY NOT NULL DATE
| CALENDAR_MONTH_NUMBER NOT NULL NUMBER(2)
| FISCAL_MONTH_NUMBER NOT NULL NUMBER(2)
| CALENDAR_MONTH_DESC NOT NULL VARCHAR2(8)
| FISCAL_MONTH_DESC NOT NULL VARCHAR2(8)
| DAYS_IN_CAL_MONTH NOT NULL NUMBER
| DAYS_IN_FIS_MONTH NOT NULL NUMBER
| END_OF_CAL_MONTH NOT NULL DATE
| END_OF_FIS_MONTH NOT NULL DATE
| CALENDAR_MONTH_NAME NOT NULL VARCHAR2(9)
| FISCAL_MONTH_NAME NOT NULL VARCHAR2(9)
| CALENDAR_QUARTER_DESC NOT NULL CHAR(7)
| FISCAL_QUARTER_DESC NOT NULL CHAR(7)
| DAYS_IN_CAL_QUARTER NOT NULL NUMBER
| DAYS_IN_FIS_QUARTER NOT NULL NUMBER
| END_OF_CAL_QUARTER NOT NULL DATE
| END_OF_FIS_QUARTER NOT NULL DATE
| CALENDAR_QUARTER_NUMBER NOT NULL NUMBER(1)
| FISCAL_QUARTER_NUMBER NOT NULL NUMBER(1)
| CALENDAR_YEAR NOT NULL NUMBER(4)
| FISCAL_YEAR NOT NULL NUMBER(4)
| DAYS_IN_CAL_YEAR NOT NULL NUMBER
| DAYS_IN_FIS_YEAR NOT NULL NUMBER
| END_OF_CAL_YEAR NOT NULL DATE
| END_OF_FIS_YEAR NOT NULL DATE
|
| and I have create one table t1
|
| desc t1
|
| Promo_name varchar2(20)
| promo_subcategory varchar2(30)
| promo_category varchar2(30)
| calendar_month_desc varchar2(8)
| total_quantity_sold number(8)
| total_amount_sold number(10,2)
|
|
|
| how insert the values in t1 table using procedure

Why using a procedure? Just use an insert select.

Regards
Michel Received on Sat Oct 18 2008 - 02:32:41 CDT