Click here to Skip to main content
11,639,126 members (67,524 online)
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.3K
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 OriginalGriff 9,081
1 Sergey Alexandrovich Kryukov 8,812
2 Mika Wendelius 7,027
3 Suvendu Shekhar Giri 2,600
4 F-ES Sitecore 2,548


Advertise | Privacy | Mobile
Web03 | 2.8.150728.1 | Last Updated 25 Aug 2012
Copyright © CodeProject, 1999-2015
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