□MySQL workbench for Mac can be installed using the MySQL installer that installs and updates all MySQL products on Mac or the standalone Mac Installer package. Or is there version with better SQL Formatting than 18.2? Like 4.2.x or 17.□Wondering "How to Install MYSQL Workbench on Mac"? watch this out to know step by step process on how to install and connect in MYSQL workbench on Mac. I've tried some 4.2 custom format workaround, but almost all lines are different in 18.2. Is there any way to import formatting from 4.1.5 to 18.2? I need to remove all of those extra line spacing and line breaks because some of my queries has thousands of lines, and the Report Builder has limitation on how much characters I can paste into it. If i have to compare it with 4.1.5 : - On select clauseSELECT NVL( hp.organization_name_phonetic, (NVL( hp.party_name, hp.party_name ) ) ) - It line breaking because the ) ) pass over max char per line || ' / ' - it line breaking because the rule to line break concatenation || ship_su_h.location sold_to oeh.creation_date so_date, -Normal line spacing- On where clauseWHERE mo.subinventory_code (+) IN ( 'aaaaaaaaa', 'bbb', 'ccccccccc', 'dddddddddd') -It line breaking because it over max char per line AND NVL( oeh.cancelled_flag, 'N' ) 'Y' AND NVL( oel.cancelled_flag, 'N' ) 'Y' -More readable lines In 18.2, there are quite a lot of extras line spacing and line breaks, and some weird formatting happening : - On select clauseSELECT nvl( hp.organization_name_phonetic, (nvl( hp.party_name, hp.party_name ) ) ) -Why the ) sign not aligned to NVL? Why there is line break at this point? And how to exclude NVL content from line breaking? || ' / ' || ship_su_h.location sold_to, oeh.creation_date so_date, -Why there are a lot white spaces in this alias? This is not occurred on all aliases, which is weird.- On where clauseWHERE mo.subinventory_code (+) IN ( 'a', 'b', 'c') - How to exclude line break on IN clause, and let it fill until max char per line? AND nvl( oeh.cancelled_flag, 'N' ) 'Y' AND nvl( oel.cancelled_flag, 'N' ) 'Y' -Again with weird alignment on NVL, which make it hard to read the code I'm currently using SQL Developer 4.1.5, and now I'm thinking to move up to SQL Developer 18.2, which i found that the formatter is "quite weird". 1.7K Training / Learning / Certification.165.3K Java EE (Java Enterprise Edition).7.8K Oracle Database Express Edition (XE).3.8K Java and JavaScript in the Database.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |