Code.GeekInterview.com
 
 

Oracle Code Base

 • Compare data in tables of the local Oracle schema
 • Converting Rows to Columns
 • Database Health check
 • Encryt and Decrypt Text messages
 • Function To Convert Amount to Words
 • Oracle Calendar SQL
 • Oracle Database Cold backup Unix
 • Oracle Database Growth Report
 • Partition Management package
 • Report Generator
 • SQL to Find Experience of an Employee
 
Code Samples Oracle
 

SQL to Find Experience of an Employee


Code ResourceAuthor: jamesravid  

Difficulty Level:

Published: 11th Dec 2006   Read: 8251 times  

Filed in: Oracle
Add Comment


 

 

Sponsored Links


 

 

This query just returns experience of employees in the format "yy years mm months dd days".

 


Sample Code
  1.  
  2.  SELECT TRUNC(SYSDATE) today,
  3.              hiredate,
  4.              TO_CHAR(TRUNC(MONTHS_BETWEEN(SYSDATE,hiredate)/12))
  5.              || ' years ' ||
  6.              TO_CHAR(MOD(TRUNC(MONTHS_BETWEEN(SYSDATE,hiredate)),12))
  7.              || ' months ' ||
  8.              TO_CHAR(TRUNC(SYSDATE) -ADD_MONTHS(hiredate,TRUNC(MONTHS_BETWEEN(SYSDATE,hiredate))))
  9.              || ' days' "Experience"  
  10.   FROM emp;
  11.  
Copyright GeekInterview.com


Next Article: Oracle Calendar SQL


 

Latest Code Samples

 ♦ Converting Rows to Columns
 ♦ Oracle Database Growth Report
 ♦ Function To Convert Amount to Words
 ♦ Report Generator
 ♦ Database Health check
 ♦ Oracle Database Cold backup Unix
 ♦ SQL to Find Experience of an Employee
 ♦ Oracle Calendar SQL
 ♦ Partition Management package
 ♦ Encryt and Decrypt Text messages
 

Popular Code Samples

 ♦ Function To Convert Amount to Words
 ♦ Converting Rows to Columns
 ♦ Oracle Calendar SQL
 ♦ Database Health check
 ♦ Oracle Database Growth Report
 ♦ Encryt and Decrypt Text messages
 ♦ Partition Management package
 ♦ SQL to Find Experience of an Employee
 ♦ Oracle Database Cold backup Unix
 ♦ Compare data in tables of the local Oracle schema
 

Related Code Samples

 » Find MAC Address
 » Find Number of Files and Sub Directories
 » UNIX Shell Program To Find Palindrome
 » Program to find out an adam number using arrays
 » Find your day from your DOB
 » Find Character/Number Functions
 

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    



Comments

good one! thanks
Comment posted by: aardvax on 2007-05-17T07:01:03

Popular Coders

# Coder NameHits
1. jamesravid39381
2. krishnaindia200732927
3. Jim.Anderson28666
4. Mohit Sharma20985
5. Beena14157
6. jainsourabh29133
7. Satheesh6002
8. SriramKrishna5010

Active Coders

# Coder NameCodes
1. jamesravid3
2. Mohit Sharma2
3. Satheesh1
4. jainsourabh21
5. SriramKrishna1
6. krishnaindia20071
7. Beena1
8. Jim.Anderson1

Refined Tags