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');

Why do we use joins?

1097

---

How you improve the performance of sql*loader? : aql loader

1060

---

Is sqlite free?

1022

---

What are the different operators available in sql?

1057

---

Is left join inner or outer?

1055

---

what is the difference between a web-garden and a web-farm? : Sql dba

1137

---

Define a temp table?

1076

---

What is a sql profiler?

1063

---

what is try_catch block in procedure

1808

---

What is sql character function?

1146

---

What is the difference between the sql*loader and import utilities? : aql loader

1088

---

How to avoid using cursors? What to use instead of cursor and in what cases to do so?

1243

---

How do you remove duplicate records from a table?

978

---

Can we create view in stored procedure?

1022

---

What are different functions in sql?

998

---