i have a table
in which i'm having a list of attributes
qId(primarykey),bid, fid(foreignkey) refering to pk),some other attributes
there is sequencer for qid.(which increments by 1)
Now i want to copy all the attribute based on bid.
wt i was doing is changing bid to new bid which solves half of my problem but im having sequencer for qid which is associated with trigger which inserts value on every insert. and due to this fid donot refer to new qid because i haven't updated it.
now i want to update that and link them to new qid generated by sequencer
thanks in advance