This discussion is archived
3 Replies Latest reply: Nov 14, 2012 10:03 AM by sb92075 RSS

table info

choti Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points