Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL Oracle
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
Posted 25-Jun-12 2:21am
Savalia_Manoj at 25-Jun-12 23:34pm
Please explain your question with example.
coded007 at 25-Sep-13 8:07am
Try to disabel the trigger and stop sequencer to update it
digimanus at 27-Jun-12 5:53am
based on the too less information it is not clear what your problem is. Please Improve your question.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 616
1 OriginalGriff 351
2 Maciej Los 210
3 Mehdi Gholam 145
4 PIEBALDconsult 140
0 Sergey Alexandrovich Kryukov 11,384
1 OriginalGriff 5,783
2 Maciej Los 5,684
3 CPallini 3,879
4 BillWoodruff 3,584

Advertise | Privacy | Mobile
Web01 | 2.8.141030.1 | Last Updated 25 Aug 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100