Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve daily sal from emp table in oracle 10g
- 2 Answers
- 6967 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 rename a column in an existing table?
Differentiate between translate and replace?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What are the database administrators utilities available?
How to convert a date to char in oracle? Give one example.
Is there any function in oracle similar like group_concat of mysql?
how to find find & delete duplicate rows from two different tables?
Explain what are the characteristics of data files?
List the various oracle database objects?
Explain about integrity constraint?
How can we view last record added to a table?
Oracle General 
