Member Avatar for chris.immanuel

Hi folks,

I have a question regarding auto-generate row oracle using sequence. So the deal is, I need to make a list of inventory based on its quantity. So I have a table with 3 columns,

  1. Component ID
  2. Quantity
  3. Sub_component.

So when user input a component id with quantity 3. I have to generate an oracle sequence of 3 that automatically inputs 3 items in the subcomponent id.

for example,

When user input component id : SX100
and the quantity is : 3

I need to generate 3 subcomponents : SX100-1, SX100-2, SX100-3

Please help me on how to achieve this ..

  • 1 Contributor
  • 1 Reply
  • 226 Views
  • 23 Seconds Discussion Span
  • Latest Post Latest Post by chris.immanuel
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.