how to retrieve daily sal from emp table in oracle 10g
- 2 Answers
- 5950 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 use attributes of the implicit cursor in oracle?
how do get database name at sql prompt?
Explain the use of grant option in exp command.
What is an oracle database table?
How to speed up webrick?
What is the implicit cursor in oracle?
What is the database name in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
What are the different types of database objects?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
What is oracle latest version?
Can a primary key contain more than one columns?
Oracle General 
