3 Replies Latest reply: Nov 14, 2012 12:04 PM by 6363 RSS

    table info

    choti
      i have a table with two columns.
      1. with sequence number 2. with year
      create table temp_yr
      (yr_key number--sequence number
      ,year_info number);
      
      How to load yearinfo data from 2006 to 2030
      expected output as
      
      
      yr_key    year_info
      1             2006
      2            2007
      3            2008
      :              :
      40          2030
      Edited by: choti on Nov 14, 2012 10:01 AM