Oracle logic in procedure

First off, Im a SQL Server developer trying to adjust to Oracle(im using TOAD) so Im feeling some growing pains but Im doing ok. I have been tasked with trying to figure out how to do the following. We have a webpage that we let end users customize. They can create banners and headers, etc....With that said, they will have the ability to move the 'tables' around on the page. They can also have multiple columns in 1 table on the page and if they would like to move one of the columns up then it will create its own row(table). The db has a table that we will be updating the ordinal positionj on the page for each table and if a row has multiple columns(3 max) they have a sub-ordinal position. In SQL I think I would be able to use CTE to iterate through the rows and columns and set their new positions? I have an excel spreadsheet that has examples for moving tables/columns up and what the outcome should be but and here are a few as well...

1st example
Moving bottom left column(5.1) up      Outcome            
4.0                        4.0      (stays the same)      
5.1      6.2                  5.0      (5.1 becomes its own row 5.0)
                        6.0      (6.2 becomes its own row 6.0)
2nd example
Moving bottom left column (5.1) up          Outcome
4.0                        4.0            
5.1      6.2      7.3            5.0          (5.1 = 5.0)      
                        6.1  7.2   (6.2 = 6.1 and 7.3 = 7.2)
      
Thanks everyone!!
jknj72Asked:
Who is Participating?
 
gatorvipCommented:
Sorry, but I don't believe you answered any of my previous questions. In fact, the last post made me think of a couple more questions:

Does what's displayed on the page correspond to underlying data stored in a database? If yes, does your "moving" concept modify that data as well?

I don't know if you meant to attach an actual spreadsheet to this thread, because it's not listed. The image you posted seems more like data moving "down" rather than "up". Also, see my previous question regarding the actual data, i.e., 4.0, 5.1, 6.3.

I may not be able to assist you further with this question. If you don't get any responses, please click on the Request Attention link under the OP. You might also want to modify the OP to add the appropriate TAs for your web environment (be it ASP, php, etc).
0
 
jknj72Author Commented:
sorry about the formatting...please see spreadsheet
0
 
jknj72Author Commented:
1st example
Moving bottom left column(5.1) up      Outcome            
4.0                        4.0      (stays the same)      
5.1      6.2                  5.0      (5.1 becomes its own row 5.0)
                        6.0      (6.2 becomes its own row 6.0)
2nd example
Moving bottom left column (5.1) up        Outcome
4.0                               4.0            
5.1      6.2      7.3                   5.0              (5.1 becomes 5.0)      
                               6.1  7.2       (6.2 becomes 6.1 and 7.3 becomes 7.2)
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
jknj72Author Commented:
Picture of logic flow
0
 
gatorvipCommented:
What does "moving" a table mean - changing the position on the webpage?
What does "6.2 = 6.1 and 7.3 = 7.2" mean?
What's the logic behind "5.1 becomes its own row 5.0" ?

They can also have multiple columns in 1 table on the page and if they would like to move one of the columns up then it will create its own row(table)
Typically database tables have multiple columns. How does "moving" a column create a row? Are you pivoting it?

The db has a table that we will be updating the ordinal positionj on the page for each table
So is it one table or more than one table?

I apologize, but to me, this thread is very confusing.  Did you mean to post this in the Oracle TA as opposed to web design/CSS?
0
 
jknj72Author Commented:
yes you are right and I knew it wuold be confusing but I tried...Anyway, I am dynamically moving tables or columns in a webpage from the bottom moving up. So in my page if I want to move a column or table up it will have a new ordinal position that I would have to update the rows too. So if I wanted to move a row(table) on the page up from position 4 on the page up to position 3 then 3 would become 4 and 4 becomes 3. In the excel spreadsheet I have some of the logic. Does this make any sense?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.