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

How to use values from other tables in update statements using oracle?

1087

---

How to view the tablespaces in the current database?

986

---

Which is better Oracle or MS SQL? Why?

6402

---

Can the query output be sorted by multiple columns in oracle?

999

---

Is oracle a relational database?

924

---

How to shutdown your 10g xe server?

1155

---

What is BBED in Oracle?

1165

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1915

---

Explain mutating triggers.

1034

---

what is insert all statement in sql

6534

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2165

---

How to use "in out" parameter properly?

1055

---

What is the oracle implicit cursor?

1068

---

How to increment dates by 1 in oracle?

1101

---

What are the general rules on data consistency?

1015

---