Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve daily sal from emp table in oracle 10g
- 2 Answers
- 6687 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 |
why dont we assign not null constraint as table level constraint.
What is self-referential integrity constraint ?
How to define an anonymous procedure with variables?
How a database is related to tablespaces?
What is the difference between translate and replace in oracle?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
how to find the n'th highest salary from emp ?
What is a Data Segment ?
Explain oracle left join with an example?
How to execute a stored procedure in oracle?
What is a table index in oracle?
What is a subquery in oracle?
Oracle General 
