[plsql] Improve XML by adding information about TABLESPACES and SEGMENTS

[hgodinez89]

Is your feature request related to a problem? Please describe.

It would be very useful to get information about the tablespaces and segments in table creation scripts. Currently, PMD don't parse this information as part of the XML.

Describe the solution you'd like

Parsing information about the tablespaces and segments in table creation scripts in PMD XML.

Describe alternatives you've considered

The only alternative may be to include this information in the XML generated by PMD.

Additional context

This is an example of a table creation script. It has a definition of tablespaces and segments for CLOB columns:

CREATE TABLE EXAMPLE_TABLE
(
 ID_COLUMN        NUMBER(10),
 LONG_DESCRIPTION CLOB,
 LONG_NOTES       CLOB
)
TABLESPACE EX_DATA
 PCTFREE 10
 PCTUSED 80
 INITRANS 1
 MAXTRANS 255
 STORAGE (
          INITIAL 160K
          NEXT 160K
          PCTINCREASE 0
          MINEXTENTS 1
          MAXEXTENTS UNLIMITED
          )
 LOB (LONG_DESCRIPTION)
 STORE AS SEG_EXAMPLETABLE_1 (
       TABLESPACE EX_INDEX
       CHUNK 4096
       CACHE
       STORAGE (
                INITIAL 160K
                NEXT 160K
                PCTINCREASE 0
               )
  INDEX IDX_EXAMPLETABLE_1 (
       TABLESPACE EX_INDEX
       STORAGE (
                INITIAL 160K
                NEXT 160K
                PCTINCREASE 0
               )
      )
 )
 LOB (LONG_NOTES)
 STORE AS SEG_EXAMPLETABLE_2 (
       TABLESPACE EX_INDEX
       CHUNK 4096
       CACHE
       STORAGE (
                INITIAL 160K
                NEXT 160K
                PCTINCREASE 0
               )
  INDEX IDX_EXAMPLETABLE_2 (
       TABLESPACE EX_INDEX
       STORAGE (
                INITIAL 160K
                NEXT 160K
                PCTINCREASE 0
               )
       )
  );

This is the current XML generated by PMD (It doesn't include TABLESPACE and SEGMENT information):

<?xml version='1.0' encoding='UTF-8'?>
<Table CanonicalImage='' Image=''>
    <ObjectNameDeclaration CanonicalImage='EXAMPLE_TABLE' Image='EXAMPLE_TABLE'>
        <ID CanonicalImage='EXAMPLE_TABLE' Image='EXAMPLE_TABLE' />
    </ObjectNameDeclaration>
    <TableColumn CanonicalImage='' Image=''>
        <ID CanonicalImage='ID_COLUMN' Image='ID_COLUMN' />
        <Datatype CanonicalImage='NUMBER(10)' Image='NUMBER(10)' TypeImage='NUMBER(10)'>
            <ScalarDataTypeName CanonicalImage='NUMBER(10)' Image='NUMBER(10)'>
                <NumericLiteral CanonicalImage='10' Image='10' />
            </ScalarDataTypeName>
        </Datatype>
    </TableColumn>
    <TableColumn CanonicalImage='' Image=''>
        <ID CanonicalImage='LONG_DESCRIPTION' Image='LONG_DESCRIPTION' />
        <Datatype CanonicalImage='CLOB' Image='CLOB' TypeImage='CLOB'>
            <ScalarDataTypeName CanonicalImage='CLOB' Image='CLOB' />
        </Datatype>
    </TableColumn>
    <TableColumn CanonicalImage='' Image=''>
        <ID CanonicalImage='LONG_NOTES' Image='LONG_NOTES' />
        <Datatype CanonicalImage='CLOB' Image='CLOB' TypeImage='CLOB'>
            <ScalarDataTypeName CanonicalImage='CLOB' Image='CLOB' />
        </Datatype>
    </TableColumn>
    <Skip2NextOccurrence CanonicalImage='' Image='' />
</Table>