Home » SQL & PL/SQL » SQL & PL/SQL » Change the order of records in some variables
Change the order of records in some variables [message #667598] Mon, 08 January 2018 05:20 Go to next message
habitusantos
Messages: 5
Registered: April 2011
Location: Portugal
Junior Member
Hello, guys i have a doubt how to perform an operation of change of the records order of certain variables without repeating them but keeping the order of the other variables as shown in the picture attached.
Thanks in advance.
Re: Change the order of records in some variables [message #667601 is a reply to message #667598] Mon, 08 January 2018 07:57 Go to previous messageGo to next message
joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA
Senior Member
Use a decode or case statement in the order by clause.
Re: Change the order of records in some variables [message #667603 is a reply to message #667598] Mon, 08 January 2018 08:01 Go to previous messageGo to next message
BlackSwan
Messages: 26703
Registered: January 2009
Location: SoCal
Senior Member
habitusantos wrote on Mon, 08 January 2018 03:20
Hello, guys i have a doubt how to perform an operation of change of the records order of certain variables without repeating them but keeping the order of the other variables as shown in the picture attached.
Thanks in advance.

Please read and follow the forum guidelines, to enable us to help you:
OraFAQ Forum Guide
How to use {code} tags and make your code easier to read
Re: Change the order of records in some variables [message #667613 is a reply to message #667598] Mon, 08 January 2018 13:03 Go to previous messageGo to next message
EdStevens
Messages: 1206
Registered: September 2013
Senior Member
Many sites block attachments for security reasons. Many of us refuse to open attachments for the same reason others block them.
Re: Change the order of records in some variables [message #667614 is a reply to message #667613] Mon, 08 January 2018 13:09 Go to previous messageGo to next message
Littlefoot
Messages: 21561
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
When saying "change", you mean UPDATE, right? If so, what's the algorithm that leads from "now" to "then"? Yes, you painted it on JPG, but - how do you explain it, using words?
Re: Change the order of records in some variables [message #667639 is a reply to message #667614] Tue, 09 January 2018 06:27 Go to previous messageGo to next message
habitusantos
Messages: 5
Registered: April 2011
Location: Portugal
Junior Member
Hi ,
Sorry foy my lack of explanation , waht i realy to make is mask (scramble) the data with reorder de records in a way that is really hard or impossible for development team or anyone else that have access to the database to reconstruct them.In practice i intend to keep some variables with the same data and the rest with different data not repeating to the original database.

Thanks for your help!
Re: Change the order of records in some variables [message #667641 is a reply to message #667639] Tue, 09 January 2018 06:36 Go to previous message
Littlefoot
Messages: 21561
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Would Masking sensitive data help in what you do?
Previous Topic: Recording Update through trigger based on csv file upload
Next Topic: PL/SQL procedure issue
Goto Forum:
  


Current Time: Fri May 29 07:18:03 CDT 2020