troubleshooting Question

Oracle procedure logic

Avatar of jknj72
jknj72 asked on
Oracle DatabaseSQL
10 Comments1 Solution355 ViewsLast Modified:
I had asked a similar(not really) question last week but after I got what I thought I needed I was wrong and this is the logic I need.....
We have a web page builder built in ASP and when a section of the page is deleted I have to be able to realign the numeric values of the row where the section was deleted. The way the page is designed is by adding certain objects to your page(Header, line, paragraph, etc...), with every object having a row number. You can add more than 1 object per row. If you have 1 object in the row, you would have a row number(in my table its the SectionOrdinal field) and a row cell number(in table its SectionCell field). I have to be able to realign the SectionCell values after an object is deleted. If there is only 1 object in the row, its SectionCell value is 0. If there is more than 1 object in the row it is 1 based, An example of the data is attached. I also have some code written in my first attempt, which I will continue to work on, but if youd like to see it let me know.....

THANKS!!

PS - I also attached a visual of how the page is built and how we are saving the row and row cell values
Ordinal-Position.doc
Realign-Sections.docx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros