OraFAQ Forum: SQL & PL/SQL » Change the order of records in some variables

Home » SQL & PL/SQL » SQL & PL/SQL » Change the order of records in some variables

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Change the order of records in some variables [message #667598]

Mon, 08 January 2018 05:20

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.

Attachment: Example_Table.jpg
(Size: 42.63KB, Downloaded 602 times)

Report message to a moderator

Re: Change the order of records in some variables [message #667601 is a reply to message #667598]

Mon, 08 January 2018 07:57

joy_division
Messages: 4949
Registered: February 2005
Location: East Coast USA

Senior Member

Use a decode or case statement in the order by clause.

Report message to a moderator

Re: Change the order of records in some variables [message #667603 is a reply to message #667598]

Mon, 08 January 2018 08:01

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

Report message to a moderator

Re: Change the order of records in some variables [message #667613 is a reply to message #667598]

Mon, 08 January 2018 13:03

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.

Report message to a moderator

Re: Change the order of records in some variables [message #667614 is a reply to message #667613]

Mon, 08 January 2018 13:09

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?

Report message to a moderator

Re: Change the order of records in some variables [message #667639 is a reply to message #667614]

Tue, 09 January 2018 06:27

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!

Report message to a moderator

Re: Change the order of records in some variables [message #667641 is a reply to message #667639]

Tue, 09 January 2018 06:36

Littlefoot
Messages: 21561
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Would Masking sensitive data help in what you do?

Report message to a moderator

Previous Topic:	Recording Update through trigger based on csv file upload
Next Topic:	PL/SQL procedure issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

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