Hi,
I am working on Oracle 11g Release 2 in Lynux. I have one table with one column and each row contains multiple years with ';' as delimiter. Same year may exists in different rows. I would like to get distinct year from the table in multiple rows. Here is the example -
with tab as (select '2001;2002;2003' year_list from dual union select '2004;2005' from dual union select '2004;2005;2006' from dual)
select * from tab;
I would like to get output like below
Year
------
2001
2002
2003
2004
2005
2006
Thank for the help.