Menu
I have query written in sqldeveloper but I don't know how to align or format the query in neat order.
P.S: I don't know whether this question can be asked here. Kindly answer if any knows the answer here.
562
You can specify different output formats using SET sqlformat <format> : SET sqlformat ansiconsole; Set that prior to your sql query and you should get a nicer format. If you look into the sqlformat option, there are others you can use, but ansiconsole is likely the one you want.
TOAD FOR ORACLE To format a statement Select the statement you want to select and click » on the Edit toolbar. To format an entire script Click » on the Edit toolbar. Tip:You can also right-click the script and select Formatting Tools | Format Code.
I have used Ctrl + f7 to format or align my query in sqldeveloper 4.7 with reference to the above comment from leo. Show activity on this post. Just right click, select FORMAT option, or, use Ctrl + f7 shortcut to format. If you have not set your own formatting rules, then it would take the default formatting.
You can press CTRL+F7 (on Windows) to format the SQL code in your current Code Editor window to update the formatting of the code based on any format changes you have made. There is no shortcut set on Mac for formatting SQL code. You can right-click in the Editor and select Format.
I have used Ctrl + f7 to format or align my query in sqldeveloper 4.7 with reference to the above comment from leo.
74
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
