Answer / anuradha

Select Count(*)
From (Select Trunc(To_Date('20120305', 'yyyymmdd'), 'MM')
+ Rownum - 1 Dates
From (Select 1 From Dual Group By Cube(2, 2, 2,
2, 2))
Where Rownum <=
Add_Months(Trunc(To_Date
('20120305', 'YYYYMMDD'), 'MM'), 1) -
Trunc(To_Date('20120305', 'YYYYMMDD'), 'MM'))
Where To_Char(Dates, 'DY') In ('SAT');

Answer / 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 trace file and how is it created in oracle?

0 Answers  

---

i have a table with 1 lac of data.i want to insert this data into another table. i want every 5000 of data insert use a commit.using counter and if error is comming in the 5000 of data it rollback.

1 Answers   MasterCard,

---

What is difference between cartesian join and cross join?

0 Answers  

---

What does a Control file Contain ?

2 Answers  

---

Explain oracle insert into command?

0 Answers  

---

Compare and contrast between sql and sql server and explain its various functions?

0 Answers  

---

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,

---

What is the string concatenation operator in oracle?

0 Answers  

---

What is an oracle data file?

0 Answers  

---

what is a view?

7 Answers  

---

How would you begin to troubleshoot an ORA-3113 error?

0 Answers  

---

can a table has a column that has only view data and in other columns we can change data?

2 Answers   Secon,

---