insert Record

[mjawadkhatri]

Hi.. this is my table info ATT_DATE NOT NULL DATE SHIFT NOT NULL VARCHAR2(8) EMP_ID NOT NULL NUMBER DEP_ID VARCHAR2(20) TIMEIN DATE TIMEOUT DATE EMP_NAME VARCHAR2(30) TOTALDAYS NUMBER i want to insert in my TOTALDAY feild the total record of an employe of one month and + total sunday in month if this possible so please please help me.... :sigh:

[Henry Minute]

With the table designed as it is, you are going to have terrible problems in getting the thing to work the way you want. At the very least the TotalDays column should be in a separate table, but this is not the only problem. There is not enough space in a forum like this to properly advise you, so I can only suggest thet you do some studying on DataBase Design, before proceeding further.

Henry Minute Do not read medical books! You could die of a misprint. - Mark Twain Girl: (staring) "Why do you need an icy cucumber?" “I want to report a fraud. The government is lying to us all.”