• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

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!!
0
jknj72
Asked:
jknj72
  • 4
  • 2
1 Solution
 
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
 
jknj72Author Commented:
Picture of logic flow
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
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
 
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

Featured Post

Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now