[hgriva]

Hi,

I have a table TARGET whose structure is

seq_no number -- should be populated with sequence SEQ_TAR
fsa varchar2(10)

Table SOURCE structure is
-------------------------
fsa varchar2(10)

my requirement is
i have to insert into the TARGET table the fsa value from
SOURCE table along with the sequence number using sequence SEQ_TAR.nextval.

[anacedent]

http://www.orafaq.com/forum/t/95496/74940/

[hgriva]

its me only.i have postaed it on the forum

[shammat]

INSERT INTO target_table (seq_no, fsa)
SELECT seq_tar.nextval, fsa
FROM source_table;

[hgriva]

hi,the code has been further modified as
test@ISNS>create table source (fsa varchar2(10),sal number);
Table created.
test@ISNS>create table target(seq_no number,fsa varchar2(10),rec_ct number);
Table created.
test@ISNS>insert into target(seq_no,fsa,rec_ct)
2 select SEQ_TAR.nextval, fsa, sum(sal)
3 from source group by fsa;

select SEQ_TAR.nextval, fsa, sum(sal)
*
ERROR at line 2:
ORA-02287: sequence number not allowed here
Kindly help me.

[shammat]

INSERT INTO target_table (seq_no, fsa, rec_ct)
SELECT seq_tar.nextval, t.fsa, t.sal
FROM (SELECT fsa, sum(sal) as sal
          FROM source_table
          GROUP BY fas);

[hgriva]

Thanks .It worked now.