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

What is before and after trigger?

964

---

What is a nested table in word?

964

---

what is the difference between clustered and non clustered index in sql? : Sql dba

1131

---

Explian rowid, rownum? What are the psoducolumns we have?

1005

---

Why plvtab is considered as the easiest way to access the pl/sql table?

1218

---

What is the purpose of a sql?

978

---

Define a temp table?

1025

---

Why functions are used in sql?

999

---

can a stored procedure call itself or recursive stored procedure? : Sql dba

1036

---

what is auto increment? : Sql dba

1015

---

What is information schema in sql?

1078

---

how to return query output in html format? : Sql dba

1079

---

What is composite primary key in sql?

1002

---

What packages are available to pl/sql developers?

1068

---

Is record in pl sql?

979

---