Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve daily sal from emp table in oracle 10g
- 2 Answers
- 6767 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 |
When do you get a .pll extension in oracle? Explain its importance
What is catalog in Oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the use of Redo Log Information ?
What are the differences between char and nchar in oracle?
what is the difference between table and veiw?
What is a connect identifier?
acname actype amount ac1 credit 300 ac2 credit 4000 ac1 debit 4000 ac2 debit 455 ac1 credit 500 how to get sum of credit and sum of debit for each account
What do you mean by a database transaction & what all tcl statements are available in oracle?
What are the differences between number and binary_float in oracle?
How to define a specific record type?
How to create a new table in oracle?
Oracle General 
