days gap between two dates

[MARKAND911]

I want to find out days gap between two dates excluding sunday.
How can i do this in oracle.
Please help me.

[debasisdas]

you need to find a function for the purpose.

[MARKAND911]

thanx Debasis.
But can help me in finding or making that function.

[MARKAND911]

i found the exact answer for it.
Here is the query for it.

SELECT count(dt) FROM
(SELECT TO_DATE('30-nov-2010') + level - 1 dt FROM dual CONNECT BY level <=(TO_DATE('12-Dec-2010')-TO_DATE('30-nov-2010')))
where to_char (dt,'D')<>1