Click here to Skip to main content
12,831,625 members (31,066 online)
Rate this:
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 3:21am
Savalia_Manoj 25-Jun-12 23:34pm
Please explain your question with example.
digimanus 27-Jun-12 5:53am
based on the too less information it is not clear what your problem is. Please Improve your question.
coded007 25-Sep-13 8:07am
Try to disabel the trigger and stop sequencer to update it

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

    Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170326.1 | Last Updated 25 Aug 2012
Copyright © CodeProject, 1999-2017
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