my totally something similar to this

Select date_value from Tab1;

The output appears like this (date_value is really a Varchar2 column)

 2008-2009
 2009-2010
 2007-2009

I'm attempting to some formatting around the column date_value,to ensure that the output appears like this

 2008-09
 2009-10
 2007-09

It is possible to method of doing this included in the above query with a couple Split/Join built-in oracle functions. I had been exploring about Instr and Substr, but i don't know how to get this done jsut for the reason that query.

SELECT SUBSTR(date_value,1,5) || SUBSTR(date_value,8,2) FROM tab1

This will work for the following ~8000 years.

If you are carrying this out on the 10g database you should use Regular Expressions.

SQL> select dcol
  2         , regexp_replace(dcol
  3                          , '([[:digit:]]+)\-([[:digit:]]{2})([[:digit:]]{2})'
  4                          , '\1-\3') as regexp_replace
  5  from t79
  6  /

DCOL                           REGEXP_REPLACE
------------------------------ ------------------------------
2008-2009                      2008-09
2009-2010                      2009-10
2007-2009                      2007-09

SQL>

Obviously, the usual caveat about regex is applicable here, even though it comes with one distinct advantage: Y10K compliance :)

SQL> select dcol
  2         , regexp_replace(dcol
  3                          , '([[:digit:]]+)\-([[:digit:]]+)([[:digit:]]{2})'
  4                          , '\1-\3') as regexp_replace
  5  from t79
  6  /

DCOL                           REGEXP_REPLACE
------------------------------ ------------------------------
2008-2009                      2008-09
2009-2010                      2009-10
2007-2009                      2007-09
10199-10200                    10199-00
887-888                        887-88

SQL>

Oracle has Formatting Query abilities. I have not used at all them, but this may piont you within the right direction.

http://www.oracle86.com/817/server.817/a82950/ch4.htm