# Alias on new line, how do I get it on the same line in the formatter options?

**URL:** <https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [February 22, 2018, 9:06am UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622 "2018-02-22T09:06:37Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![hammer15026](https://avatars.discourse-cdn.com/v4/letter/h/c0e974/32.png) [@hammer15026](https://forums.toadworld.com/u/hammer15026)\
**Post date:** [February 22, 2018, 9:06am UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622/1 "2018-02-22T09:06:37Z")

</div>

I’m using 12.12.0.39 Toad for Oracle.

using the formatter it puts pseudo names on a new line.

For example.

SELECT 2  
SQL\_CODE,  
SOLDCUST.NAME  
CONTRACT\_CUSTOMER\_NAME,  
FROMCUST.NAME  
BA\_ASSGN\_TO\_CUSTOMER\_NAME,  
FROMCUST.LOCATION\_CODE  
BA\_ASSGN\_SHIPTO\_LOCATION,

I want this to look like this

SELECT 2 SQL\_CODE,  
SOLDCUST.NAME CONTRACT\_CUSTOMER\_NAME,  
FROMCUST.NAME BA\_ASSGN\_TO\_CUSTOMER\_NAME,  
FROMCUST.LOCATION\_CODE BA\_ASSGN\_SHIPTO\_LOCATION,

I can not find the settings in the formatter options to set this.

Thanks

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [February 25, 2018, 11:26pm UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622/2 "2018-02-25T23:26:34Z")

</div>

Hello hammer15026,

I’m getting your desired format as soon as I set the right margin setting to 59 or higher.

Thanks,  
Andre

---

<div class="post-metadata">

**Author:** ![aybrady](https://avatars.discourse-cdn.com/v4/letter/a/bcef8e/32.png) [@aybrady](https://forums.toadworld.com/u/aybrady)\
**Post date:** [April 12, 2018, 11:48am UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622/3 "2018-04-12T11:48:20Z")

</div>

I am also having this problem can we please get a fix for this?

---

<div class="post-metadata">

**Author:** ![dwmosman](https://avatars.discourse-cdn.com/v4/letter/d/59ef9b/32.png) [@dwmosman](https://forums.toadworld.com/u/dwmosman)\
**Post date:** [April 13, 2018, 4:16pm UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622/4 "2018-04-13T16:16:18Z")

</div>

Here's a case of the problem. The margin is set to 100 (using Toad Beta 13.0.0.69)

The following script will be reformatted with alias's moved to the following line. However, if you delete the four lines with the concatenated case statement, then the alias's will work properly and will NOT be moved to the next line.

SELECT  
sgb.sgbstdn\_pidm person\_uid  
, tcc.academic\_period\_mod  
|| CASE  
WHEN sgb.sgbstdn\_coll\_code\_1 in ('FC','GS') THEN '5'  
ELSE '0'  
END academic\_period  
, tcc.academic\_period\_mod  
, sgb.sgbstdn\_levl\_code student\_level  
, sgb.sgbstdn\_coll\_code\_1 college  
, tcc.academic\_year  
, tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb  
ON sgb.sgbstdn\_pidm = tcc.person\_uid

Code with Case Statement

 ![toad formatter alias issue1 889-320.png](https://global.discourse-cdn.com/quest/original/2X/c/c88c2294718240c1aa360ba45936c56421448eb1.png)

Code with Case Reformatted

 ![toad formatter alias issue2 890-429.png](https://global.discourse-cdn.com/quest/original/2X/5/5e7a5ca814185e36201b15fb18455a43e3a78373.png)

Code without Case

 ![toad formatter alias issue3 890-238.png](https://global.discourse-cdn.com/quest/original/2X/a/a868c58322cfd20397710d4b61848f3023860c3e.png)

Code without Case Reformatted

 ![toad formatter alias issue4 890-297.png](https://global.discourse-cdn.com/quest/original/2X/6/69890981b063ff838230db3714f0b7fb39619ee2.png)

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [April 17, 2018, 9:19am UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622/5 "2018-04-17T09:19:04Z")

</div>

Formatter folds from the top of the statement downwards until everything fits inside the margin. As the CASE clause on a single line is way too long it has to be folded. But the expression is “more downward” than the aliases, so the aliases fold first.

Originally I tried to improve the visualization by aligning all aliases, but you are right in that a long CASE statement - which should be folded - should not spoil the game.

I’ll look how to fix that. (QP-2931)

Thanks,  
Andre

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [May 11, 2018, 2:04pm UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622/6 "2018-05-11T14:04:17Z")

</div>

For now I fixed it in QP5 version 5.330 as follows (formatted forms while varying the margin from wide to narrow):

SELECT sgb.sgbstdn\_pidm person\_uid,  
tcc.academic\_period\_mod || CASE WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’) THEN ‘5’ ELSE ‘0’ END academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code student\_level,  
sgb.sgbstdn\_coll\_code\_1 college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc INNER JOIN saturn.sgbstdn sgb ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm  
person\_uid,  
tcc.academic\_period\_mod || CASE WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’) THEN ‘5’ ELSE ‘0’ END  
academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code  
student\_level,  
sgb.sgbstdn\_coll\_code\_1  
college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc INNER JOIN saturn.sgbstdn sgb ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm  
person\_uid,  
tcc.academic\_period\_mod || CASE WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’) THEN ‘5’ ELSE ‘0’ END  
academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code  
student\_level,  
sgb.sgbstdn\_coll\_code\_1  
college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm person\_uid,  
tcc.academic\_period\_mod  
|| CASE WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’) THEN ‘5’ ELSE ‘0’ END academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code student\_level,  
sgb.sgbstdn\_coll\_code\_1 college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm  
person\_uid,  
tcc.academic\_period\_mod  
|| CASE WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’) THEN ‘5’ ELSE ‘0’ END  
academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code  
student\_level,  
sgb.sgbstdn\_coll\_code\_1  
college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm person\_uid,  
tcc.academic\_period\_mod  
|| CASE  
WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’) THEN ‘5’  
ELSE ‘0’  
END academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code student\_level,  
sgb.sgbstdn\_coll\_code\_1 college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm person\_uid,  
tcc.academic\_period\_mod  
|| CASE  
WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’) THEN ‘5’  
ELSE ‘0’  
END academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code student\_level,  
sgb.sgbstdn\_coll\_code\_1 college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb  
ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm person\_uid,  
tcc.academic\_period\_mod  
|| CASE  
WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’)  
THEN  
‘5’  
ELSE  
‘0’  
END academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code student\_level,  
sgb.sgbstdn\_coll\_code\_1 college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb  
ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm person\_uid,  
tcc.academic\_period\_mod  
|| CASE  
WHEN sgb.sgbstdn\_coll\_code\_1 IN  
(‘FC’, ‘GS’)  
THEN  
‘5’  
ELSE  
‘0’  
END academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code student\_level,  
sgb.sgbstdn\_coll\_code\_1 college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb  
ON sgb.sgbstdn\_pidm = tcc.person\_uid;

SELECT sgb.sgbstdn\_pidm  
person\_uid,  
tcc.academic\_period\_mod  
|| CASE  
WHEN sgb.sgbstdn\_coll\_code\_1 IN (‘FC’, ‘GS’)  
THEN  
‘5’  
ELSE  
‘0’  
END  
academic\_period,  
tcc.academic\_period\_mod,  
sgb.sgbstdn\_levl\_code  
student\_level,  
sgb.sgbstdn\_coll\_code\_1  
college,  
tcc.academic\_year,  
tcc.academic\_year\_desc  
FROM odsmgr.z\_total\_credits\_by\_col\_vw tcc  
INNER JOIN saturn.sgbstdn sgb  
ON sgb.sgbstdn\_pidm =  
tcc.person\_uid;

( hmm, the IN(…) should be folded as well… )

Is this any better?

Thanks,  
Andre

---

<div class="post-metadata">

**Author:** ![avergison](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/avergison/32/66_2.png) [@avergison](https://forums.toadworld.com/u/avergison)\
**Post date:** [May 14, 2018, 4:52am UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622/7 "2018-05-14T04:52:40Z")

</div>

(please copy/paste using a Courier or similar font, this board fails to show it this way)

---

<div class="post-metadata">

**Author:** ![deshin13](https://avatars.discourse-cdn.com/v4/letter/d/f04885/32.png) [@deshin13](https://forums.toadworld.com/u/deshin13)\
**Post date:** [August 17, 2018, 9:33am UTC](https://forums.toadworld.com/t/alias-on-new-line-how-do-i-get-it-on-the-same-line-in-the-formatter-options/40622/8 "2018-08-17T09:33:40Z")

</div>

Hi there,

Where can I download the latest formatter options from?

Thanks in advance.
