Sqldeveloper adds spaces between schema and object
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;
The latest version of Sqldeveloper (18.3) seems to break autoformatting.
sample query
select * from hr.whatever;
in 18.2, the query would format to
select *
from hr.whatever;
now, sqldeveloper 18.3 (using the same settings) is formatting this to
select *
from hr . whatever ;
the spaces between schema and object are annoying - and I found no way of switching this off.
I tried to copy the default "custom formatting" from 18.2 to 18.3, however this does not help.
My formatting options:
Hope someone is able to point me to the proper formatting option to disable this.
formatting oracle-sqldeveloper
edited Nov 15 '18 at 8:06
a_horse_with_no_name
307k46468567
asked Nov 15 '18 at 8:05
MatthiasMatthias
13217
add a comment |
The latest version of Sqldeveloper (18.3) seems to break autoformatting.
sample query
select * from hr.whatever;
in 18.2, the query would format to
select *
from hr.whatever;
now, sqldeveloper 18.3 (using the same settings) is formatting this to
select *
from hr . whatever ;
the spaces between schema and object are annoying - and I found no way of switching this off.
I tried to copy the default "custom formatting" from 18.2 to 18.3, however this does not help.
My formatting options:
Hope someone is able to point me to the proper formatting option to disable this.
formatting oracle-sqldeveloper
edited Nov 15 '18 at 8:06
a_horse_with_no_name
307k46468567
asked Nov 15 '18 at 8:05
MatthiasMatthias
13217
1
It's a bug in 18.3 - reset your formatter preferences and you'll be back to 'normal.' this has been fixed for 18.4
– thatjeffsmith
Nov 15 '18 at 9:12
Thanks Jeff, that's what i've been looking for.
– Matthias
Nov 15 '18 at 13:47
add a comment |
The latest version of Sqldeveloper (18.3) seems to break autoformatting.
sample query
select * from hr.whatever;
in 18.2, the query would format to
select *
from hr.whatever;
now, sqldeveloper 18.3 (using the same settings) is formatting this to
select *
from hr . whatever ;
the spaces between schema and object are annoying - and I found no way of switching this off.
I tried to copy the default "custom formatting" from 18.2 to 18.3, however this does not help.
My formatting options:
Hope someone is able to point me to the proper formatting option to disable this.
formatting oracle-sqldeveloper
edited Nov 15 '18 at 8:06
a_horse_with_no_name
307k46468567
asked Nov 15 '18 at 8:05
MatthiasMatthias
13217
The latest version of Sqldeveloper (18.3) seems to break autoformatting.
sample query
select * from hr.whatever;
in 18.2, the query would format to
select *
from hr.whatever;
now, sqldeveloper 18.3 (using the same settings) is formatting this to
select *
from hr . whatever ;
the spaces between schema and object are annoying - and I found no way of switching this off.
I tried to copy the default "custom formatting" from 18.2 to 18.3, however this does not help.
My formatting options:
Hope someone is able to point me to the proper formatting option to disable this.
formatting oracle-sqldeveloper
formatting oracle-sqldeveloper
edited Nov 15 '18 at 8:06
a_horse_with_no_name
307k46468567
asked Nov 15 '18 at 8:05
MatthiasMatthias
13217
edited Nov 15 '18 at 8:06
a_horse_with_no_name
307k46468567
asked Nov 15 '18 at 8:05
MatthiasMatthias
13217
edited Nov 15 '18 at 8:06
a_horse_with_no_name
307k46468567
edited Nov 15 '18 at 8:06
a_horse_with_no_name
307k46468567
edited Nov 15 '18 at 8:06
a_horse_with_no_name
307k46468567
307k46468567
asked Nov 15 '18 at 8:05
MatthiasMatthias
13217
asked Nov 15 '18 at 8:05
MatthiasMatthias
13217
asked Nov 15 '18 at 8:05
MatthiasMatthias
13217
13217
1
It's a bug in 18.3 - reset your formatter preferences and you'll be back to 'normal.' this has been fixed for 18.4
– thatjeffsmith
Nov 15 '18 at 9:12
Thanks Jeff, that's what i've been looking for.
– Matthias
Nov 15 '18 at 13:47
add a comment |
1
It's a bug in 18.3 - reset your formatter preferences and you'll be back to 'normal.' this has been fixed for 18.4
– thatjeffsmith
Nov 15 '18 at 9:12
Thanks Jeff, that's what i've been looking for.
– Matthias
Nov 15 '18 at 13:47
1
1
It's a bug in 18.3 - reset your formatter preferences and you'll be back to 'normal.' this has been fixed for 18.4
– thatjeffsmith
Nov 15 '18 at 9:12
It's a bug in 18.3 - reset your formatter preferences and you'll be back to 'normal.' this has been fixed for 18.4
– thatjeffsmith
Nov 15 '18 at 9:12
Thanks Jeff, that's what i've been looking for.
– Matthias
Nov 15 '18 at 13:47
Thanks Jeff, that's what i've been looking for.
– Matthias
Nov 15 '18 at 13:47
add a comment |
1 Answer
1
active
oldest
votes
This is a bug.
Happens when you upgrade to 18.3 AND if you -
If a customer has ever visited the Custom Format Page, and hit OK (not
Cancel) when leaving it (even though he never touch the Arbori code),
then the new Arbori program would be saved (with all the
consequences).
Consequences being what you see.
To get the formatter working as expected again, hit this button.
This bug has been fixed for version 18.4, due later this year.
answered Nov 15 '18 at 13:34
thatjeffsmiththatjeffsmith
8,43211448
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53314856%2fsqldeveloper-adds-spaces-between-schema-and-object%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
This is a bug.
Happens when you upgrade to 18.3 AND if you -
If a customer has ever visited the Custom Format Page, and hit OK (not
Cancel) when leaving it (even though he never touch the Arbori code),
then the new Arbori program would be saved (with all the
consequences).
Consequences being what you see.
To get the formatter working as expected again, hit this button.
This bug has been fixed for version 18.4, due later this year.
answered Nov 15 '18 at 13:34
thatjeffsmiththatjeffsmith
8,43211448
add a comment |
This is a bug.
Happens when you upgrade to 18.3 AND if you -
If a customer has ever visited the Custom Format Page, and hit OK (not
Cancel) when leaving it (even though he never touch the Arbori code),
then the new Arbori program would be saved (with all the
consequences).
Consequences being what you see.
To get the formatter working as expected again, hit this button.
This bug has been fixed for version 18.4, due later this year.
answered Nov 15 '18 at 13:34
thatjeffsmiththatjeffsmith
8,43211448
add a comment |
This is a bug.
Happens when you upgrade to 18.3 AND if you -
If a customer has ever visited the Custom Format Page, and hit OK (not
Cancel) when leaving it (even though he never touch the Arbori code),
then the new Arbori program would be saved (with all the
consequences).
Consequences being what you see.
To get the formatter working as expected again, hit this button.
This bug has been fixed for version 18.4, due later this year.
answered Nov 15 '18 at 13:34
thatjeffsmiththatjeffsmith
8,43211448
This is a bug.
Happens when you upgrade to 18.3 AND if you -
If a customer has ever visited the Custom Format Page, and hit OK (not
Cancel) when leaving it (even though he never touch the Arbori code),
then the new Arbori program would be saved (with all the
consequences).
Consequences being what you see.
To get the formatter working as expected again, hit this button.
This bug has been fixed for version 18.4, due later this year.
answered Nov 15 '18 at 13:34
thatjeffsmiththatjeffsmith
8,43211448
answered Nov 15 '18 at 13:34
thatjeffsmiththatjeffsmith
8,43211448
answered Nov 15 '18 at 13:34
thatjeffsmiththatjeffsmith
8,43211448
answered Nov 15 '18 at 13:34
thatjeffsmiththatjeffsmith
8,43211448
8,43211448
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53314856%2fsqldeveloper-adds-spaces-between-schema-and-object%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
It's a bug in 18.3 - reset your formatter preferences and you'll be back to 'normal.' this has been fixed for 18.4
– thatjeffsmith
Nov 15 '18 at 9:12
Thanks Jeff, that's what i've been looking for.
– Matthias
Nov 15 '18 at 13:47