Answer Posted / anil kumar

select sum(1) from table_name;

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?

1377

---

How do I limit the number of oracle database connections generated by weblogic server?

1058

---

How to manage transaction isolation level?

996

---

How to insert multiple rows with one insert statement in oracle?

1070

---

Explain an index segment?

1100

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2055

---

What is the difference between hot backup and cold backup in oracle?

1005

---

How many file formats are supported to export data?

1206

---

What is the difference between Delete, Truncate and Drop in Oracle?

1120

---

What is an oracle and why it is used?

1138

---

How to create an oracle database manually?

1071

---

Does oracle database need java?

992

---

An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?

2040

---

How can I convert single byte kana characters into multi byte kana characters and vice-versa.

2388

---

Which is better Oracle or MS SQL? Why?

4918

---