SQL & PL/SQL

Hi,

I'm able to get count of days in current month as of today but not able to exclude weekends. Please advise.

My query


SELECT TRUNC(SYSDATE)-TRUNC(SYSDATE,'MM') FROM DUAL


I want very simple query something like show below. please don't use connect and level key words because they aren't supported by OBIEE.

SELECT TRUNC(SYSDATE)-TRUNC(SYSDATE,'MM') FROM DUAL
where wday not in ('sat','sun');

Thanks
Jay