Answer Posted / nagaraju

select count(*) from (
select trunc(to_date(sysdate,'DD/MM/rrrr'),'mm') +rownum -1 dates
from dual connect by level <=Add_Months(trunc(to_date(sysdate,'DD/MM/rrrr'),'mm'),1) - trunc(to_date(sysdate,'DD/MM/rrrr'),'mm')
)
where
to_char(dates,'DY')='SAT'

What is a oracle database?

1011

---

What are internal user account in oracle?

960

---

How to use an explicit cursor without open statements?

1022

---

How can we find out the duplicate values in an oracle table?

1010

---

What is translate in oracle?

1060

---

How to view all columns in an existing table?

896

---

What do you mean by merge in oracle and how can you merge two tables?

924

---

Explain rename?

938

---

What is a server parameter file in oracle?

1021

---

Explain an index segment?

1066

---

How to update values on multiple rows in oracle?

994

---

How do I find the database name in oracle?

1000

---

How to get execution path reports on query statements?

945

---

List out the types of joins.

1109

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

978

---