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 |
Can sub procedure/function be called recursively?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
waht is the difference between primary key and super key?
Give the various exception types.
Can a formula column be obtained through a select statement ?
What are the factors causing the reparsing of SQL statements in SGA?
What are a cluster and non-cluster index?
Difference between varchar and varchar2 data types?
How to check the oracle tns settings?
How many data types are supported?
What is logical backup in oracle?