Answer Posted / shailesh

I think what Anuradha has suggested is fine but it may not
produce accurate results. I think following query should
return reliable results based on number of days present in
month.

select trunc(salary/ to_number(extract (day from last_day
(sysdate))),2) as daily_sal,salary from employees

What is the data pump import utility?

969

---

Is primary key indexed by default in oracle?

931

---

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2302

---

Explain coalesce function?

1119

---

Why do you create or replace procedures rather that drop and recreate.

948

---

How to check the oracle tns settings?

991

---

A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.

5417

---

How do I use os authentication with weblogic jdriver for oracle and connection pools?

999

---

What are the advantages of oracle 12c?

1121

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1023

---

What is the difference between alert log file and tarce file ?

2099

---

What is a relational database management system?

1064

---

How do I uninstall oracle client from windows?

962

---

What happens to the current transaction if the session is killed?

927

---

What is hash cluster in oracle?

1091

---