# Toad formatting options

**URL:** <https://forums.toadworld.com/t/toad-formatting-options/9903>\
**Category:** Toad for Oracle & DevOps Toolkit\
**Created:** [October 4, 2010, 10:46am UTC](https://forums.toadworld.com/t/toad-formatting-options/9903 "2010-10-04T10:46:15Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![n.tenbrink\_984](https://avatars.discourse-cdn.com/v4/letter/n/3e96dc/32.png) [@n.tenbrink\_984](https://forums.toadworld.com/u/n.tenbrink_984)\
**Post date:** [October 4, 2010, 10:46am UTC](https://forums.toadworld.com/t/toad-formatting-options/9903/1 "2010-10-04T10:46:15Z")

</div>

How to do this?

In TOAD i want to format my query:

select xmlelement(  
“value”  
,xmlforest(  
code as “code\_a”  
)  
like this

select xmlelement(“value”,  
xmlforest(code as “code\_a”)
