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:
I would prefer to have it formatted as this:
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
);
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
);