View SQL on Table Edit Beutifier

Felix

Member²
The code generated when I click on the View SQL button for Table Edit/View makes all keywords lower case. I would prefere upper case and the column names lower case.

It generates this:

Code:
create table ERROR_LOG
(
  ERROR_NUM       NUMBER(22) not null,
  USER_ID         VARCHAR2(8) not null,
  ERROR_DATE      DATE not null,
  ERROR_TIME      DATE not null,
  DBERROR_NO      NUMBER(22),
  DBERROR_TEXT    VARCHAR2(2000),
  ADDITIONAL_TEXT VARCHAR2(256),
  WINDOW_NAME     VARCHAR2(40),
  ERROR_LABEL     VARCHAR2(80)
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 160K
    minextents 1
    maxextents unlimited
  );
I would prefer to have it formatted as this:

Code:
CREATE TABLE error_log
(
  error_num       NUMBER(22) NOT NULL,
  user_id         VARCHAR2(8) NOT NULL,
  error_date      DATE NOT NULL,
  error_time      DATE NOT NULL,
  dberror_no      NUMBER(22),
  dberror_text    VARCHAR2(2000),
  additional_text VARCHAR2(256),
  window_name     VARCHAR2(40),
  error_label     VARCHAR2(80)
)
TABLESPACE users
  PCTFREE 10
  INITRANS 1
  MAXTRANS 255
  STORAGE
  (
    INITIAL 160K
    MINEXTENTS 1
    MAXEXTENTS UNLIMITED
  );
 
Back
Top