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 write numeric literals in oracle?

1236

---

What is a sub query? Describe its types?

1072

---

In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?

2388

---

What is a database schema in oracle?

1151

---

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1746

---

How to load data through external tables?

1189

---

What are ddl statements in oracle?

1128

---

How to start instance with a minimal initialization parameter file?

1085

---

What is meant by joins? List out the types of joins.

1104

---

How will you identify oracle database software release?

1058

---

what is IDE,DMV in sql server?

2880

---

How to get the Installed Oracle Version Information ?

1189

---

What are the data types in oracle?

1096

---

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.

2056

---

What are the differences between lov and list item?

1144

---