SQL query help needed (Oracle)
 

Using Oracle SQP*Plus at the moment.

I have two dates in DATE format. I want to know if there is a way of deducting one date from the other (for example START_DATE and FINISH_DATE) to show EXPERIENCE.

Anyone any ideas at all??

Thanks in advance :)

check this out http://psoug.org/reference/date_func.html
there is example with making diff function on the bottom