plscope-utils for SQL Developer v1.0.0

New

• #21 Support sequences in PL/Scope tree (SQLDev)
• #26 Add column module_name to plscope_identifiers (Core)
• #39 Various new columns in plscope_identifiers view (Core)
• #40 Simplify Identifiers editor in SQLDev extension (SQLDev)
• Remove Primary and Secondary nodes in the PL/Scope tree (SQLDev)
• Make alle nodes int the PL/Scope tree filterable (SQLDev)

Fixed

• #20 Wrong icon shown for procedure in PL/Scope tree (SQLDev)
• #25 Cannot compile package parse_util in Oracle Database 18c (Core)
• #30 No access to UTL_XML / UTL_XML_LIB in ATP (Core)
• #33 Loop in Dependency Graph (Core, SQLDev)
• #39 Forward declarations not considered in procedure_scope of plscope_identifiers (Core)
• #41 Do not use sys_context('userenv', 'authenticated_identity') for schemas (Core, SQLDev)
• False naming convention violations (Core, SQLDev)
• Empty links in editors and reports (SQLDev)

Behind the Scenes

• #23 Initial JUnit tests for SQL Developer Extension (SQLDev)
• #22 Initial Unit Tests for Core Database Objects (Core)
• #31 Test failures when running on 19c PDB (Core)
• #34 ORA-01489: result of string concatenation is too long (Core, SQLDev)
• #35 Automatically format all code in this repository (Core)
• #36 Format SQL and PL/SQL files (Core, SQLDev)
• Fix Violations of Trivadis PL/SQL & SQL Coding Guidelines
• Do not use public synonyms that are not compiled with PL/Scope (Core, SQLDev)

plscope-utils for SQL Developer v0.6.0

Version 0.6.0

• New

  • #19 Support report "Unused Local Identifiers" in Oracle Database 11.1 to 12.1

• Fixed

  • #18 Identifiers view not working on Oracle Database < 12.2

plscope-utils for SQL Developer v0.5.2

Version 0.5.2

• Improved

  • When a usage_id is missing in the hierarchy a suitable alternative is used (see also #17)

• Fixed

  • #17 Missing row in plscope_identifiers

plscope-utils for SQL Developer v0.5.1

Version 0.5.1

• Fixed
  • #16 Viewers for "Identifiers", "Uses" and "Table Usages" are slow for PDB connections

plscope-utils for SQL Developer v0.5.0

Version 0.5.0

• New
  • #10 Report "Trivadis PL/SQL Naming Conventions"
  • #15 Add viewer "Uses"
• Fixed
  • #11 Report "CRUD Operations" needs the view plscope_identifiers to be installed
  • #12 Report "UDF Calls in SQL Statements" is slow
  • #13 Report "Unused Local Identifiers" is slow

plscope-utils for SQL Developer v0.4.2

Version 0.4.2

• Fixed
  • #9 12c columns such as ORIGIN_CON_ID must not be selected in 11g queries

plscope-utils for SQL Developer v0.4.1

Version 0.4.1

• Fixed
  • #7 Report "Unused Local Identifiers" uses dba_* views
  • #8 Extension is not loaded in SQL Developer 17.2.0

plscope-utils for SQL Developer v0.4.0

Version 0.4.0

• Initial GA Release
• Extension for Oracle SQL Developer
  • Adds PL/Scopenode to the database navigator tree
  • Adds Compile with PL/Scope context menu on the connection and PL/Scope node
  • Adds viewers/editors for tables, views and PL/SQL nodes
  • Adds plsql-utils Reports folder
• Prerequisites
  • Oracle SQL Developer 4.0.0 or higher
  • Oracle Database Server 11g Release 1 or higher

plscope-utils v0.3.0

Version 0.3.0

• New
  • #4 Add is_used column to plscope_identifiers
  • #5 Add procedure_scope column to plscope_identifiers
• Fixed
  • #3 Wrong result when PL/Scope hierarchy is inconsistent

plscope-utils v0.2.0

Version 0.2.0

• New
  • #1 Add dba_source.text column to plscope_identifiers
  • #2 Add parent_statement_type column to plscope_identifiers