Skip to content
This repository was archived by the owner on Aug 30, 2024. It is now read-only.
This repository was archived by the owner on Aug 30, 2024. It is now read-only.

Create table / create tablespace not formatting properly #211

Closed
#222
Closed
Create table / create tablespace not formatting properly#211
#222
Assignees
PhilippSalvisberg
Labels
documentationImprovements or additions to documentationenhancementNew feature or request
Milestone
SQLcl 22.2.1
@jhult

Description

@jhult
jhult
opened on Jul 6, 2022

Using trivadis_custom_format.arbori inside Oracle SQLDeveloper (Version 21.4.3.063 Build 063.0100)

Before:

CREATE TABLE configuration (id NUMBER NOT NULL);

CREATE TABLESPACE my_table_space DATAFILE 'my_tablespace_file.dbf' SIZE 50M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

After:

CREATE TABLE configuration (id NUMBER NOT NULL);

CREATE TABLESPACE my_table_space DATAFILE 'my_tablespace_file.dbf' SIZE 50M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED EXTENT
MANAGEMENT LOCAL AUTOALLOCATE;

Expected:

CREATE TABLE configuration (
   id NUMBER NOT NULL
);

CREATE TABLESPACE my_table_space
   DATAFILE 'my_tablespace_file.dbf' SIZE 50M
   AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
   EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

I get the same results when using the standalone formatter.

If I use the default arbori that ships with SQLDeveloper, it formats properly (matches Expected above). This works both inside SQLDeveloper and with the standalone formatter.

Metadata

Metadata

Assignees

Labels

documentationImprovements or additions to documentationenhancementNew feature or request

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions