PS Query & SQL

 View Only
  • 1.  Format SQL

    Posted 01-22-2025 03:51 PM

    For those times you need to format your SQL to improve readability.....

    Instant SQL Formatter & Beautifier Online

    Dpriver remove preview
    Instant SQL Formatter & Beautifier Online
    Free online sql formatting tool, beautify sql code instantly for SQL Server, Oracle, DB2, MySQL, Sybase, Access and MDX
    View this on Dpriver >



    ------------------------------
    Jim Longano
    Sr. Software Applications Developer - ERP
    University of Cincinnati
    longanjm@uc.edu
    ------------------------------
    Alliance 2026 Registration is Open!


  • 2.  RE: Format SQL

    Posted 01-22-2025 04:01 PM

    Jim,

    I use it all the time.



    ------------------------------
    Daniel Labrecque
    Senior 2 Business Systems Analyst/Functional Architect
    University of Nevada, Las Vegas
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!


  • 3.  RE: Format SQL

    Posted 01-23-2025 11:44 AM
      |   view attached

    I use the Oracle SQL Developer IDE. You can format SQL statements by selecting the SQL statement(s) and use the Ctrl-F7 shortcut. You can also right click after the selection and click on Format. 



    ------------------------------
    Enrique Pizana
    PeopleSoft Developer and Support Engineer
    Washington State Board for Community and Technical Colleges
    ------------------------------

    Message from the HEUG Marketplace:
    ------------------------------
    Find, Review, and Engage with Higher Education-focused solution providers, products, and services using the HEUG Marketplace.
    ------------------------------

    Alliance 2026 Registration is Open!