Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve daily sal from emp table in oracle 10g
- 2 Answers
- 6925 Views
- Infosys, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How do I limit the number of rows returned by an oracle query after ordering?
What happens to the current transaction if the session is ended?
What are the benefits of ordbms?
How to enter a new row into a table interactively?
How do I manually uninstall oracle client?
How to list all tables in your schema?
How can I get column names from a table in oracle?
How to invoke the data pump import utility?
How to grant create session privilege to a user in oracle?
What is system tablespace?
How to connect ms access to oracle servers?
How to start instance with a minimal initialization parameter file?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
Why oracle is used?
How to convert characters to dates in oracle?
