how to retrieve daily sal from emp table in oracle 10g
Answer Posted / 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 |
Post New Answer View All Answers
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What is tns entry?
Explain a synonym?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
How can we create the complete backup of data in the oracle.
How to define an explicit cursor in oracle?
Can we store images in oracle database?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What are a cluster and non-cluster index?
How do I know if oracle client is installed on windows?
src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));
How to view all columns in an existing table?
How can we find out the current date and time in oracle?
what is port in oracle? how is it related to database application.
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??