SELECT COUNT( *) FROM (SELECT ROWNUM RNUM FROM ALL

using subquery how can i calculate working days in a month?

Question Posted / mayru

3 Answers
12968 Views
Spice Telecom, I also Faced
E-Mail Answers

Answer Posted / mayru

SELECT COUNT( *)
FROM
(SELECT ROWNUM RNUM
FROM ALL_OBJECTS
WHERE ROWNUM <= TO_DATE('01-OCT-2011') - TO_DATE('01-SEP-2011') + 1
)
WHERE TO_CHAR(TO_DATE('01-SEP-2011') + RNUM - 1, 'DY') NOT IN('SAT', 'SUN');

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql procedures and functions?

954

What is a scalar value in sql?

1010

What is the purpose of the sql select top clause?

1018

what is timestamp in mysql? : Sql dba

998

Explain what is sql?

1053

What is pl sql script?

975

what is 'mysqladmin' in mysql? : Sql dba

971

Does truncate free space?

943

what is innodb? : Sql dba

1029

What is difference between stored procedure and trigger?

1055

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

989

What are the types of records?

951

What is group function in sql?

960

Why should I use postgresql?

966

Is a table valued function object?

958