Depends on what you do and what language you work with. As a simple example, right now I'm working with a Visual Basic.NET application that has several queries. I generally do all my work with queries in Toad, but Visual Basic.NET has an annoying syntax when it comes to long lines, namely:
Public Const SelectData As String = _ "SELECT * " & _ "FROM myTable " & _ "WHERE myField = :SOMETHING"
Since I really donโt like editing queries when I copy them from code or paste them back, I have some macros that will automatically format or format them from them.
In addition, some macros can be used to automate common tasks that need to be performed while the development environment is running. Any sequence of commands that you often see is something you can turn into a macro and do it with just one click.
rjzii source share