Click here to Skip to main content
Rate this: bad
good
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
preet881.2K
Comments
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