![]() Question: I would like to know if it's possible to use the DECODE function for ranges of numbers, ie 1-10 = 'category 1', 11-20 = 'category 2', rather than having to individually decode each number.Īnswer: Unfortunately, you can not use the DECODE function for ranges of numbers. The date example above could be modified as follows: LEAST(date1, date2) Helpful Tip #2: One of our viewers suggested using the LEAST function (instead of the DECODE function) as follows: Sales Bonuses DECODE(SIGN(actual-target), -1, 'NO Bonus for you', 0,'Just made it', 1, 'Congrats, you are a winner') The SIGN/DECODE combination is also helpful for numeric comparisons e.g. The date example above could be modified as follows: DECODE(SIGN(date1-date2), 1, date2, date1) Helpful Tip #1: One of our viewers suggested combining the SIGN function with the DECODE function as follows: The formula below would equal 0, if date1 is greater than date2: (date1 - date2) - ABS(date1 - date2) Otherwise, the DECODE function should return date1.Īnswer: To accomplish this, use the DECODE function as follows: DECODE((date1 - date2) - ABS(date1 - date2), 0, date2, date1) You should have received a copy of the GNU Lesser General Public License along with sqldeveloperpassworddecryptor.Question: One of our viewers wanted to know how to use the DECODE function to compare two dates (ie: date1 and date2), where if date1 > date2, the DECODE function should return date2. See the GNU Lesser General Public License for more details. ![]() Sqldeveloperpassworddecryptor is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. ![]() Sqldeveloperpassworddecryptor is free software: you can redistribute it and/or modify it under the terms of the GNU Lesser General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version. version 1.2 - : replacing P圜rypto by P圜ryptodomex for these reasons.version 2.1 - : new encryption type support (from v19.2).Or manually install P圜ryptodome: pip install pycryptodomex. ![]() The easiest way to setup everything: pip install sqldeveloperpassworddecryptor and then directly use $ sqldeveloperpassworddecryptor.For the Jython version: well, only Jython ( apt-get install jython or download it here).encrypted password: LUA63VW21TqaHNJSvKF6DI8zv1/dvXzBhyMPVN8lAws= Sqldeveloperpassworddecryptor.py version 2.1 When exporting one or more connections from version 4, the user is asked to type a password: that password is then used as a key to encrypt the entries instead of the db.system.id value. Windows: %APPDATA%\SQL Developer\system\o.sqldeveloper\product-preferences.xml.Linux: ~/.sqldeveloper/system/o.sqldeveloper./product-preferences.xml.Windows: %APPDATA%\SQL Developer\system\o.sqldeveloper.\product-preferences.xml.Passwords are stored encrypted in the aforementioned connections.xml and connections.json file but the encryption key by default uses an installation-unique random UUID value db.system.id in the product-preferences file. Linux: ~/.sqldeveloper/system/o.jdeveloper.db.connection/connections.json.Windows: %APPDATA%\SQL Developer\system\o.jdeveloper.db.connection\connections.json.Passwords are stored encrypted in the connections.json file in those locations: Linux: ~/.sqldeveloper/system/o.jdeveloper.db.connection./connections.xml.Windows: %APPDATA%\SQL Developer\system\o.jdeveloper.db.connection.\connections.xml.Passwords are stored encrypted in the connections.xml file in those locations: Comes in 2 flavors: a Jython and a Python script.Support old (v3, v4->v19.1) and new (from v19.2) password encryption.SQL Developer password decryptor DescriptionĪ simple script to decrypt stored passwords from the Oracle SQL Developer IDE.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |