Interested to Buy Any Domain ? << Click Here >> for more details...
how to retrieve daily sal from emp table in oracle 10g
- 2 Answers
- 7162 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 table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
20. Using a set operator, display the client number of all clients who have never placed an order.
What is connection pooling in oracle?
What to do if the startbd.bat failed to start the xe instance?
What is java oracle used for?
How to use values from other tables in update statements using oracle?
What is where clause in oracle?
what is null value?
What is a tns service name?
how to clone 9i Database on to 10g Database.
What is partitioned table in Oracle?
sql command 2 know current database
Oracle General 
