Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve daily sal from emp table in oracle 10g
- 2 Answers
- 6755 Views
- Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / anuradha
Select empno,ename,sal, sal/30 "Daily_Sal" From emp;
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / 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 |
How to view existing locks on the database?
How to remove a row in a database table?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is a system tablespace and when it is created?
Can we save images in a database and if yes, how?
How to create a table index in oracle?
How to select some rows from a table in oracle?
How do I spool to a csv formatted file using sqlplus?
What is the minimum client footprint required to connect c# to an oracle database?
Briefly explain what is literal? Give an example where it can be used?
What happens if variable names collide with table/column names?
What is logical backup in oracle?
Oracle General 
