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 nested table?

1053

---

hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.

2256

---

Can you have more than one content canvas view attached with a window ?

2328

---

How do I connect to oracle?

1027

---

how may join possible between (requisition with purchase order)

2241

---

What is key preserved table?

1013

---

What is translate in oracle?

1093

---

How can I introduce multiple conditions in like operator?

982

---

Explain joins in oracle?

1033

---

Is oracle an operator?

923

---

What is the difference between view and materialized view in Oracle?

1147

---

what are actual and formal parameters?

1104

---

Explain oracle 12c new features for developers?

1052

---

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1380

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4358

---