Format sql query in TOAD 7.

sql format toad
murtaza.webdev picture murtaza.webdev · Mar 31, 2014 · Viewed 34.9k times · Source

In toad's older version i can easily able to format the query in

Toad's Query editor by

  right click > Format Code.

But in newer version of Toad 7 i can't able to find this Format option. Can any one help me from where i can Format My Query.

(how to FORMAT QUERY in TOAD 7?)

Answer

SriniV picture SriniV · Mar 31, 2014

TOAD FOR ORACLE

SHIFT+CTRL+F should help you

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.

See the documentation

TOAD FOR MYSQL

Format SQL

Use the formatter to modify the layout of SQL in the Editor, including inserting headers, adding or removing extra lines, and changing the case for keywords.

To format SQL

Click Paint shaped box on the Editor toolbar to format the contents of the Editor window. You can also format a partial statement in the Editor by selecting it before applying formatting.

See documentation

Related questions

Oracle SQL - DATE greater than statement

As the title says, I want to find a way to check which of my data sets are past 6 months from SYSDATE via query. SELECT * FROM OrderArchive WHERE OrderDate <= '31 Dec 2014'; I've tried the following but it returns …

Read More
SQL date format convert? [dd.mm.yy to YYYY-MM-DD]

is there mySQL function to convert a date from format dd.mm.yy to YYYY-MM-DD? for example, 03.09.13 -> 2013-09-03.

Read More
Python String Formats with SQL Wildcards and LIKE

I'm having a hard time getting some sql in python to correctly go through MySQLdb. It's pythons string formatting that is killing me. My sql statement is using the LIKE keyword with wildcards. I've tried a number of different things …

Read More