how to retrieve daily sal from emp table in oracle 10g
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 |
Explain an exception and its types?
How do you find current date and time in oracle?
What is a system tablespace?
After using set unused can we enable the column again to use? Please give me some answers....
How would you change old and new values in an insert, delete and update triggers?
What happens to the data files if a tablespace is dropped?
What is a sub query? Describe its types?
how will I find the first 5 highest salaried employees in each dept in oracle.
write sql query following source are EmpID, Salary 101 1000 102 2000 103 3000 I want the output format like following empid,sal,composite_sal 101 1000 1000 102 2000 3000 103 3000 6000
What is Network Database link ?
what are the advantages of running a database in NO archive log mode?
How do I connect to oracle?