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 |
What is a dynamic performance view in oracle?
How to display the hierarchy of employee and managers without using connect by prior.
which clause we are not used in where clause?
What do you mean by cdb and pdb in oracle 12c?
How to assign a tablespace to a users in oracle?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
Explain an integrity constrains?
How to connect ms access to oracle servers?
What is STATSPACK tool?
How remove data files before opening a database?
How to view the tablespaces in the current database?
How to update a table row with a record?