|
On Mon, 3 Feb 2003 11:40:14 -0500, Rathore, Ritesh (GECP, TEMP, 096462) wrote:
>SELECT EMP_NO, EMP_NAME, SUM(DECODE(STATUS, 'PRESENT' , 1, 0))
>TOTAL_PRESENT, SUM(DECODE(STATUS, 'ABSENT', 1, 0))
>TOTAL_ABSENT, SUM(DECODE(STATUS,'SICK LEAVE', 1, 0))
>TOTAL_SICK_LEAVE, FROM ACTUAL_TABLE GROUP BY EMP_NO, EMP_NAME
Thanks for your mail. Yah ! I found my right solution using this SQL Command. Further thanks a lot.
I am facing another problem. If possible, Please let me know. How can i make a good solution for that.
I have a MS Excel file. File Name emp.xls Here has all employee information.
How can i will Import all of data from MS Excel file to Oracle Database as a same table .
Please Help me as per as possible.
Thanks and Beast Regards ...
G.K.M. Shafiul Alam Bhuiyan
(Computer Programmer)
| 
