Edit Distribution Set – Oracle 11i User
I would like to know how to insert a new data record into the middle an existing Oracle Distribution Set, rather than add new data at the end of the set.
Software/Hardware used:
Oracle 11i
Software/Hardware used:
Oracle 11i
ASKED:
August 13, 2009 4:24 PM
UPDATED:
August 13, 2009 6:22 PM
RELATED QUESTIONS
- migrate from oracle 9 to oracle 11
- Distribution list keeps disappearing in Outlook 2007
- Distribution Group with a different domain
- MS-Access data inserted in to Oracle 11g CLOB
- TableAdapterManager contains no connection information. Set each TableAdapterManager TableAdapter property to a valid TableAdapter instance.
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
You will need to specify what Oracle product you are using.
I’m pretty new to Oracle with minimal training, but I am using Distribution Sets in entering invoices into accounts payable. I have set up Distribution Sets for the account breakdown for recurring invoices that have numerous general ledger codes applied to them. The distributions are in a particular order that follow the order of items on an invoice. If a new item is introduced on an invoice, I would like to enter that item into the middle of the Distribution Set so as to follow the order on the invoice. I can’t figure out how to insert a record into the middle of a Distribution Set. Thanks.