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 are the different pseudo commands? Explain in general?

653

---

How to concatenate two text values in oracle?

691

---

What are the differences between char and varchar2 in oracle?

652

---

What is a table index in oracle?

735

---

Explain integrity constraints?

763

---

---

What operating systems are supported by oracle database 10g xe?

683

---

How to define an anonymous procedure with variables?

626

---

State the various uses of dbcc command?

648

---

What is a package ? What are the advantages of package ?

698

---

What are triggers in oracle?

659

---

What is using clause and give example?

674

---

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

1828

---

What are the uses of a database trigger?

596

---

Explain the use of owner option in exp command.

649

---

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

1821

---